SUPPORT / SAMPLES & SAS NOTES
Problem Note 65219: You query a term in the SAS® Business Data Network 3.3 API, and the result returns ". . .error errorCode= '0' httpStatusCode= '500'. . ."
 |  |  |  |  |
You use the API to query a term and receive result details that are similar to the following:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><error errorCode="0"
httpStatusCode="500"><details/><links/><message>java.lang.NullPointerException
occurred.</message><remediation></remediation><version>1</version></error>
httpStatusCode="500"><details/><links/><message>java.lang.NullPointerException
occurred.</message><remediation></remediation><version>1</version></error>
The query fails because "Y" is flagged for the column "sas_bdn_dgobjs.dg_pend" in the Postgres instance of the SAS® Data Management server database "dmbdndb." The “Y” flag indicates that a deletion of the term is already pending.
The error does not occur when you query the term in the web UI.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Business Data Network | Solaris for x64 | 3.3 | 9.4 TS1M6 | ||
| Linux for x64 | 3.3 | 9.4 TS1M6 | ||||
| HP-UX IPF | 3.3 | 9.4 TS1M6 | ||||
| 64-bit Enabled Solaris | 3.3 | 9.4 TS1M6 | ||||
| 64-bit Enabled AIX | 3.3 | 9.4 TS1M6 | ||||
| Microsoft® Windows® for x64 | 3.3 | 9.4 TS1M6 | ||||