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 | ||||
A fix for this issue for SAS Business Data Network Mid-Tier 3.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/F9W.html#66383| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-07-29 10:35:01 |
| Date Created: | 2020-07-28 16:32:01 |