Question

2
Replies
155
Views
AshwinK999 Member since 2012 3 posts
Stratosphere Consulting
Posted: 5 years ago
Last activity: 5 years ago
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
Share this page LinkedIn