Did you ever get the following exception while deploying projects in BCC especially in case of an automated load or bulk load using importRepository or startSQLRepository utilities?
CONTAINER:atg.deployment.manifest.ManifestException;
SOURCE:atg.versionmanager.exceptions.VersionException: Unable to check in
workspace testProject.
at
atg.deployment.loader.RepositoryDataLoader.addError(RepositoryDataLoader.java:2069)
at
atg.deployment.loader.RepositoryDataLoader.doImport(RepositoryDataLoader.java:2722)
at
atg.deployment.loader.RepositoryDataLoader.execute(RepositoryDataLoader.java:1529)
at
atg.deployment.loader.RepositoryDataLoader.main(RepositoryDataLoader.java:1484)
Caused by: atg.versionmanager.exceptions.VersionException:
Unable to check in workspace gopicheckin5.
at
atg.versionmanager.impl.WorkspaceRepositoryImpl.checkInAll(WorkspaceRepositoryImpl.java:1166)
at
atg.deployment.loader.RepositoryDataLoader.checkIn(RepositoryDataLoader.java:2977)
at
atg.deployment.loader.RepositoryDataLoader.doImport(RepositoryDataLoader.java:2718)
... 2 more
Caused by: CONTAINER:atg.repository.RepositoryException;
SOURCE:java.sql.SQLException: ORA-00932: inconsistent datatypes: expected CHAR
got NUMBER
at
atg.adapter.version.VersionItemDescriptor.isAnyOutOfDate(VersionItemDescriptor.java:7288)
at
atg.adapter.version.VersionRepository.checkInInternalOptimized(VersionRepository.java:3188)
at
atg.adapter.version.VersionRepository.checkIn(VersionRepository.java:3120)
at
atg.versionmanager.impl.WorkspaceRepositoryImpl.checkInAll(WorkspaceRepositoryImpl.java:1143)
... 4 more
Caused by: java.sql.SQLException: ORA-00932: inconsistent
datatypes: expected CHAR got NUMBER
If anybody got this error, I am sure that you must have spent lot of time to figuring out whats the issue, indeed I had spent lot of time :)
Anyway there is no direct mapping between the error message displayed on the logs and the actual issue. The error logs must be misguiding you to look into your DB logs since the error had thrown from the DB (SQLException).
So what is the actual issue here? It is very simple, most of the time you will get this error when the number of assets in the project is more than configured (Strange indeed, why can't ATG give a proper error message- no idea on that ).
To resolve this issue, we need to update the total asset allowed in the project using the below component.
/atg/epub/version/VersionManagerService.workspaceOptimizationThresholdAssetCount
