Select Your Region
Americas
Europe
Middle East & Africa
Asia Pacific
SUPPORT / SAMPLES & SAS NOTES
Problem Note 66383: The error "org.springframework.jdbc.BadSqlGrammarException" occurs when you use the snapshot functionality in SAS® Business Data Network (SAS® 9.4M7)
 |  |  |  |  |
In SAS Business Data Network on SAS 9.4M7, the following error occurs when you try to create a snapshot:
org.springframework.jdbc.BadSqlGrammarException
When this error happens, the functionality does not work. The problem occurs because the PostgreSQL database system in SAS 9.4M7 has been upgraded from version 9.5 to 12.3. During the upgrade, the structure of sequences changed, which prevents the ability to copy schema in SAS Business Data Network.
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 | Microsoft® Windows® for x64 | 3.3 | 9.4 TS1M7 | ||
| 64-bit Enabled AIX | 3.3 | 9.4 TS1M7 | ||||
| 64-bit Enabled Solaris | 3.3 | 9.4 TS1M7 | ||||
| HP-UX IPF | 3.3 | 9.4 TS1M7 | ||||
| Linux for x64 | 3.3 | 9.4 TS1M7 | ||||
| Solaris for x64 | 3.3 | 9.4 TS1M7 | ||||