Question

2
Replies
161
Views
Ashwin Vemula (AshwinK999)
Stratosphere Technical Consulting
Lead System Architect
Stratosphere Technical Consulting
US
AshwinK999 Member since 2012 3 posts
Stratosphere Technical Consulting
Posted: October 6, 2015
Last activity: October 26, 2015
Posted: 6 Oct 2015 22:29 EDT
Last activity: 26 Oct 2015 12:03 EDT
Closed
Solved

Joining Data-WorkAttachFile is throwing DB Exceptions (SQLCODE=-206, SQLSTATE=42703, DRIVER=3.64.133)

I posted the same error in this PDN link as well:

https://pdn.pega.com/reporting/twenty-seven-commonly-used-join-conditions-for-list-view-and-summary-view-reports#comment…

I joined Data-WorkAttach-File as shown in the above link and got the below error:

** There was a problem getting a list: code: -206 SQLState: 42703 Message: "File.PXOBJCLASS" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.64.133


Also searching for the Hot Fix number as mentioned in this topic: https://pdn.pega.com/forums/prpc/reporting/join-error

Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.