After Upgrade OAS 6.4 TO OAS 2024 Exportarchive Is Failing With Invalid Column JOB_ID
(Doc ID 3035451.1)
Last updated on JULY 17, 2024
Applies to:
Oracle Analytics Server - Version 2024 and laterInformation in this document applies to any platform.
Symptoms
OAS 2024 (Inplace Upgrade from OAS 6.4)
Windows 2019
RCU SQL Server 2019
After upgrade exportarchive from command line, and create snapshot from DV is failing with invalid column JOB_ID.
exportarchive.cmd ssi ssi.bar
ProdHome:D:\oas2024home\bi
DomainHome:D:\oasdomain\bi
Enter bar encryption password within 5 seconds:
Export archive is running...
List credential (index: connect_string username)
Export Archive Failed with Error : Operation Failed
ERR:Plugin:oracle.bi.web.datasetsvc.car.plugin.metadata.OfflineDSSStoragePlugin:beginExport Operation:exportBAR StatusCode:Operation Failed
Log dir :D:\oasdomain\bi\bilogs\metadata\exportbar_20240711_093350_1832517895
ProdHome:D:\oas2024home\bi
DomainHome:D:\oasdomain\bi
Enter bar encryption password within 5 seconds:
Export archive is running...
List credential (index: connect_string username)
Export Archive Failed with Error : Operation Failed
ERR:Plugin:oracle.bi.web.datasetsvc.car.plugin.metadata.OfflineDSSStoragePlugin:beginExport Operation:exportBAR StatusCode:Operation Failed
Log dir :D:\oasdomain\bi\bilogs\metadata\exportbar_20240711_093350_1832517895
Export logs shows the following error:
Caused by: oracle.bi.web.datasetsvc.api.direct.exception.DirectApiInternalException: oracle.bi.web.datasetsvc.api.core.exception.ArchiveException: java.sql.SQLException: java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid column name 'JOB_ID'.
at oracle.bi.web.datasetsvc.api.direct.v2.DirectApiImpl.exportContentArchive(DirectApiImpl.java:134)
at oracle.bi.web.datasetsvc.car.plugin.offline.DirectAPIClient.exportContentArchive(DirectAPIClient.java:48)
... 16 more
Caused by: oracle.bi.web.datasetsvc.api.core.exception.ArchiveException: java.sql.SQLException: java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid column name 'JOB_ID'.
at oracle.bi.web.datasetsvc.api.direct.v2.DirectApiImpl.exportContentArchive(DirectApiImpl.java:134)
at oracle.bi.web.datasetsvc.car.plugin.offline.DirectAPIClient.exportContentArchive(DirectAPIClient.java:48)
... 16 more
Caused by: oracle.bi.web.datasetsvc.api.core.exception.ArchiveException: java.sql.SQLException: java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid column name 'JOB_ID'.
Changes
Inplace Upgrade
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |