Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: n3vek7 on November 15, 2016, 03:53:45 AM
-
Hey guys,
I've recently installed GIM 8.5 with RAA 8.5 and I'm using two ICONs 8.1 (Core and Cfg).
So far, there's no agent activity on my environment.
All applications starts fine, however I keep getting an error from GIM about the table mentionned in the subject ;
[code]
2016-11-13 16:48:06,684 INFO main 30000 Propagating exception Invalid object name 'ABCD_GIM85User.CTL_UD_TO_UDE_MAPPING'. in columnExists(CTL_UD_TO_UDE_MAPPING.CONVERT_EXPRESSION)
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ABCD_GIM85User.CTL_UD_TO_UDE_MAPPING'.
[/code]
In SQL Studio, selecting the table ABCD_GIM85User.CTL_UD_TO_UDE_MAPPING won't work.
I need to perform a select on ABCD_GIM85.[b]dbo[/b].CTL_UD_TO_UDE_MAPPING.
It's like GIM is using [[b]User[/b]].CTL_UD_TO_UDE_MAPPING but SQL want [b][Database].dbo.[/b]CTL_UD_TO_UDE_MAPPING
I've double checked and the user defined in the DAP has the role DBOWNER on GIM Database !
Am I missing a configuration in MSSQL ? (I really have the impression this is where's my problem!!)
And yes, there's data in this table (39 rows inserted by the sql_scripts provided by GIM)
p.s. I tried to cheat a little by renaming the user for the name of the database and it didn't work, SQL is really waiting for the ".dbo."
Here's a screenshot showing user mapping in SQL Server ;
[url=https://n3vek7.tinytake.com/sf/MTExOTE2NF80NDI4MzM4]https://n3vek7.tinytake.com/sf/MTExOTE2NF80NDI4MzM4[/url]
More logs :
[code]
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'ICONMM_KEYS'='ICONMM_DB1'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'GIM_DBUrl'='jdbc:sqlserver://SERVER-WITH-SQL:1433;DatabaseName=ABCD_GIM85;SelectMethod=cursor'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'ICONMM_DB1DAP'='DAP_ICON_Core'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'GIM_DBName'='ABCD_GIM85'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'ICONMM_DB1LoginValue'='ABCD_IconUserSuperSecretPWD!!'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'ICONCORE_KEYS'='ICONCORE_DB1'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'ICONCORE_DB1Server'='SERVER-WITH-SQL'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'ICONMM_DB1Engine'='mssql'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'ICONCORE_DB1Name'='ABCD_Icon'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'ICONCORE_DB1Url'='jdbc:sqlserver://SERVER-WITH-SQL:1433;DatabaseName=ABCD_Icon;SelectMethod=cursor'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'GIM_DBDriver'='com.microsoft.sqlserver.jdbc.SQLServerDriver'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'ICONCORE_DB1Engine'='mssql'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'GIM_DBDAP'='DAP_GIM'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'ICONMM_DB1DefaultSchema'='ABCD_IconUser'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'ICONMM_DB1Url'='jdbc:sqlserver://SERVER-WITH-SQL:1433;DatabaseName=ABCD_Icon;SelectMethod=cursor'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'ICONCORE_DB1LoginValue'='ABCD_IconUserSuperSecretPWD!!'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'GIM_DBServer'='SERVER-WITH-SQL'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'ICONMM_DB1Driver'='com.microsoft.sqlserver.jdbc.SQLServerDriver'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'GIM_DBLoginKey'='dap_gim.11'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'GIM_DBLoginValue'='ABCD_GIM85UserSuperSecretPWD!!'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'ICONMM_DB1LoginKey'='dap_icon_cor.14'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'ICONCORE_DB1DefaultSchema'='ABCD_IconUser'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'GIM_DBDefaultSchema'='ABCD_GIM85User'.
2016-11-13 16:48:06,168 INFO main 30101 Option 'Connections':'ICONMM_DB1Name'='ABCD_Icon'.
2016-11-13 16:48:06,184 INFO main 30101 Option 'Connections':'ICONMM_DB1Server'='SERVER-WITH-SQL'.
2016-11-13 16:48:06,184 INFO main 30101 Option 'Connections':'ICONCORE_DB1DAP'='DAP_ICON_Core'.
2016-11-13 16:48:06,184 INFO main 30101 Option 'Connections':'ICONCORE_DB1LoginKey'='dap_icon_cor.14'.
2016-11-13 16:48:06,184 INFO main 30101 Option 'Connections':'GIM_DBEngine'='mssql'.
2016-11-13 16:48:06,184 INFO main 30101 Option 'Connections':'ICONCORE_DB1Driver'='com.microsoft.sqlserver.jdbc.SQLServerDriver'.
2016-11-13 16:48:06,184 INFO main 30101 Option 'Connections':'124.101'='ABCD_SIPServer[124,0,101]'.
2016-11-13 16:48:06,184 INFO main 30101 Option 'Connections':'99.0'='CFG'.
2016-11-13 16:48:06,200 INFO main 30000 Memory free=8011 K; committed=21888 K; max=614400 K
2016-11-13 16:48:06,512 INFO GIMListener-1 31401 GIM Listener - listener localhost - tcp://[anylocal]:7000 opened.
2016-11-13 16:48:06,684 INFO main 30000 Propagating exception Invalid object name 'ABCD_GIM85.CTL_UD_TO_UDE_MAPPING'. in columnExists(CTL_UD_TO_UDE_MAPPING.CONVERT_EXPRESSION)
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ABCD_GIM85.CTL_UD_TO_UDE_MAPPING'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteCursored(SQLServerStatement.java:1853)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:749)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:611)
at com.genesyslab.gim.etl.util.jdbc.SQLUtils.columnExists(SQLUtils.java:2519)
at com.genesyslab.gim.etl.util.jdbc.SQLUtils.columnExists(SQLUtils.java:2508)
at com.genesyslab.gim.etl.dao.JdbcDaoSupport.columnExists(JdbcDaoSupport.java:59)
at com.genesyslab.gim.etl.beans.ctl.CtlUdToUdeMappingDao$Jdbc$1Impl.<init>(CtlUdToUdeMappingDao.java:51)
at com.genesyslab.gim.etl.beans.ctl.CtlUdToUdeMappingDao$Jdbc.load(CtlUdToUdeMappingDao.java:96)
at com.genesyslab.gim.etl.beans.ctl.UdeMapping.<init>(UdeMapping.java:156)
at com.genesyslab.gim.etl.beans.ctl.UdeMapping.getUdeTableNames(UdeMapping.java:110)
at com.genesyslab.gim.etl.beans.ctl.UdeMapping.getUdeFactTableNames(UdeMapping.java:105)
at com.genesyslab.gim.etl.jobs.maintain.PurgeParameters.loadCustomTableNames(PurgeParameters.java:95)
at com.genesyslab.gim.etl.jobs.maintain.PurgeParameters.getAllPurgedTableNamesFilter(PurgeParameters.java:85)
at com.genesyslab.gim.etl.server.GimSqlFactoryManager.newSqlFactory(GimSqlFactoryManager.java:29)
at com.genesyslab.gim.etl.server.GimSqlFactoryManager.newSqlFactory(GimSqlFactoryManager.java:16)
at com.genesyslab.gim.etl.server.AbstractSqlFactoryManager.getSQLFactory(AbstractSqlFactoryManager.java:79)
at com.genesyslab.gim.etl.server.Environment$Configurator.configure(Environment.java:172)
at com.genesyslab.gim.etl.server.JobController.getEnvironment(JobController.java:1252)
at com.genesyslab.gim.etl.server.JobController.doDBCall(JobController.java:537)
at com.genesyslab.gim.etl.server.JobController.load(JobController.java:703)
at com.genesyslab.gim.etl.server.JobController.initialize(JobController.java:714)
at com.genesyslab.gim.etl.server.JobController.initializeOnce(JobController.java:1294)
at com.genesyslab.gim.etl.server.JobController$FsmContext.isInitialized(JobController.java:1022)
at com.genesyslab.gim.etl.server.DefaultScheduler$State$1.next(DefaultScheduler.java:23)
at com.genesyslab.gim.etl.server.DefaultScheduler.run(DefaultScheduler.java:292)
at com.genesyslab.gim.etl.server.JobController.tick(JobController.java:804)
at com.genesyslab.gim.etl.server.GIMServer.doMain(GIMServer.java:441)
at com.genesyslab.gim.etl.server.GIMServer.main(GIMServer.java:472)
2016-11-13 16:48:06,700 ERROR main 20155 Database error: Invalid object name 'ABCD_GIM85.CTL_UD_TO_UDE_MAPPING'.; CODE=208; SQLSTATE=S0002; DBError=UNCATEGORIZED; SQL=[ SELECT * FROM ABCD_GIM85.CTL_UD_TO_UDE_MAPPING T WHERE 1 = 0 ], conn=1358607789,ConnectionID:1.
2016-11-13 16:48:06,700 ERROR main 20000 JobController: getPurgedTableNames() failed while initializing
com.genesyslab.gim.etl.exceptions.InvalidConfiguration: getPurgedTableNames() failed
at com.genesyslab.gim.etl.jobs.maintain.PurgeParameters.getAllPurgedTableNamesFilter(PurgeParameters.java:88)
at com.genesyslab.gim.etl.server.GimSqlFactoryManager.newSqlFactory(GimSqlFactoryManager.java:29)
at com.genesyslab.gim.etl.server.GimSqlFactoryManager.newSqlFactory(GimSqlFactoryManager.java:16)
at com.genesyslab.gim.etl.server.AbstractSqlFactoryManager.getSQLFactory(AbstractSqlFactoryManager.java:79)
at com.genesyslab.gim.etl.server.Environment$Configurator.configure(Environment.java:172)
at com.genesyslab.gim.etl.server.JobController.getEnvironment(JobController.java:1252)
at com.genesyslab.gim.etl.server.JobController.doDBCall(JobController.java:537)
at com.genesyslab.gim.etl.server.JobController.load(JobController.java:703)
at com.genesyslab.gim.etl.server.JobController.initialize(JobController.java:714)
at com.genesyslab.gim.etl.server.JobController.initializeOnce(JobController.java:1294)
at com.genesyslab.gim.etl.server.JobController$FsmContext.isInitialized(JobController.java:1022)
at com.genesyslab.gim.etl.server.DefaultScheduler$State$1.next(DefaultScheduler.java:23)
at com.genesyslab.gim.etl.server.DefaultScheduler.run(DefaultScheduler.java:292)
at com.genesyslab.gim.etl.server.JobController.tick(JobController.java:804)
at com.genesyslab.gim.etl.server.GIMServer.doMain(GIMServer.java:441)
at com.genesyslab.gim.etl.server.GIMServer.main(GIMServer.java:472)
Caused by: com.genesyslab.gim.etl.exceptions.UncategorizedSQLException: columnExists; Uncategorized SQLException for SQL [SELECT * FROM ABCD_GIM85.CTL_UD_TO_UDE_MAPPING T WHERE 1 = 0]; SQLSTATE=S0002; error code=208; DBError=UNCATEGORIZED; Invalid object name 'ABCD_GIM85.CTL_UD_TO_UDE_MAPPING'.
at com.genesyslab.gim.etl.exceptions.SQLExceptionTranslator.translate(SQLExceptionTranslator.java:56)
at com.genesyslab.gim.etl.exceptions.SQLExceptionTranslator.translate(SQLExceptionTranslator.java:28)
at com.genesyslab.gim.etl.util.jdbc.SQLUtils.columnExists(SQLUtils.java:2530)
at com.genesyslab.gim.etl.util.jdbc.SQLUtils.columnExists(SQLUtils.java:2508)
at com.genesyslab.gim.etl.dao.JdbcDaoSupport.columnExists(JdbcDaoSupport.java:59)
at com.genesyslab.gim.etl.beans.ctl.CtlUdToUdeMappingDao$Jdbc$1Impl.<init>(CtlUdToUdeMappingDao.java:51)
at com.genesyslab.gim.etl.beans.ctl.CtlUdToUdeMappingDao$Jdbc.load(CtlUdToUdeMappingDao.java:96)
at com.genesyslab.gim.etl.beans.ctl.UdeMapping.<init>(UdeMapping.java:156)
at com.genesyslab.gim.etl.beans.ctl.UdeMapping.getUdeTableNames(UdeMapping.java:110)
at com.genesyslab.gim.etl.beans.ctl.UdeMapping.getUdeFactTableNames(UdeMapping.java:105)
at com.genesyslab.gim.etl.jobs.maintain.PurgeParameters.loadCustomTableNames(PurgeParameters.java:95)
at com.genesyslab.gim.etl.jobs.maintain.PurgeParameters.getAllPurgedTableNamesFilter(PurgeParameters.java:85)
... 15 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ABCD_GIM85.CTL_UD_TO_UDE_MAPPING'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteCursored(SQLServerStatement.java:1853)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:749)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:611)
at com.genesyslab.gim.etl.util.jdbc.SQLUtils.columnExists(SQLUtils.java:2519)
... 24 more
2016-11-13 16:48:21,725 INFO main 30000 Propagating exception Invalid object name 'ABCD_GIM85.CTL_UD_TO_UDE_MAPPING'. in columnExists(CTL_UD_TO_UDE_MAPPING.CONVERT_EXPRESSION)
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ABCD_GIM85.CTL_UD_TO_UDE_MAPPING'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteCursored(SQLServerStatement.java:1853)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:749)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:611)
at com.genesyslab.gim.etl.util.jdbc.SQLUtils.columnExists(SQLUtils.java:2519)
at com.genesyslab.gim.etl.util.jdbc.SQLUtils.columnExists(SQLUtils.java:2508)
at com.genesyslab.gim.etl.dao.JdbcDaoSupport.columnExists(JdbcDaoSupport.java:59)
at com.genesyslab.gim.etl.beans.ctl.CtlUdToUdeMappingDao$Jdbc$1Impl.<init>(CtlUdToUdeMappingDao.java:51)
at com.genesyslab.gim.etl.beans.ctl.CtlUdToUdeMappingDao$Jdbc.load(CtlUdToUdeMappingDao.java:96)
at com.genesyslab.gim.etl.beans.ctl.UdeMapping.<init>(UdeMapping.java:156)
at com.genesyslab.gim.etl.beans.ctl.UdeMapping.getUdeTableNames(UdeMapping.java:110)
at com.genesyslab.gim.etl.beans.ctl.UdeMapping.getUdeFactTableNames(UdeMapping.java:105)
at com.genesyslab.gim.etl.jobs.maintain.PurgeParameters.loadCustomTableNames(PurgeParameters.java:95)
at com.genesyslab.gim.etl.jobs.maintain.PurgeParameters.getAllPurgedTableNamesFilter(PurgeParameters.java:85)
at com.genesyslab.gim.etl.server.GimSqlFactoryManager.newSqlFactory(GimSqlFactoryManager.java:29)
at com.genesyslab.gim.etl.server.GimSqlFactoryManager.newSqlFactory(GimSqlFactoryManager.java:16)
at com.genesyslab.gim.etl.server.AbstractSqlFactoryManager.getSQLFactory(AbstractSqlFactoryManager.java:79)
at com.genesyslab.gim.etl.server.Environment$Configurator.configure(Environment.java:172)
at com.genesyslab.gim.etl.server.JobController.getEnvironment(JobController.java:1252)
at com.genesyslab.gim.etl.server.JobController.doDBCall(JobController.java:537)
at com.genesyslab.gim.etl.server.JobController.load(JobController.java:703)
at com.genesyslab.gim.etl.server.JobController.initialize(JobController.java:714)
at com.genesyslab.gim.etl.server.JobController.initializeOnce(JobController.java:1294)
at com.genesyslab.gim.etl.server.JobController$FsmContext.isInitialized(JobController.java:1022)
at com.genesyslab.gim.etl.server.DefaultScheduler$State$1.next(DefaultScheduler.java:23)
at com.genesyslab.gim.etl.server.DefaultScheduler.run(DefaultScheduler.java:292)
at com.genesyslab.gim.etl.server.JobController.tick(JobController.java:804)
at com.genesyslab.gim.etl.server.GIMServer.doMain(GIMServer.java:441)
at com.genesyslab.gim.etl.server.GIMServer.main(GIMServer.java:472)
2016-11-13 16:48:21,741 ERROR main 20155 Database error: Invalid object name 'ABCD_GIM85.CTL_UD_TO_UDE_MAPPING'.; CODE=208; SQLSTATE=S0002; DBError=UNCATEGORIZED; SQL=[ SELECT * FROM ABCD_GIM85.CTL_UD_TO_UDE_MAPPING T WHERE 1 = 0 ], conn=2007226471,ConnectionID:2.
2016-11-13 16:48:21,741 ERROR main 20000 JobController: getPurgedTableNames() failed while initializing
com.genesyslab.gim.etl.exceptions.InvalidConfiguration: getPurgedTableNames() failed
at com.genesyslab.gim.etl.jobs.maintain.PurgeParameters.getAllPurgedTableNamesFilter(PurgeParameters.java:88)
at com.genesyslab.gim.etl.server.GimSqlFactoryManager.newSqlFactory(GimSqlFactoryManager.java:29)
at com.genesyslab.gim.etl.server.GimSqlFactoryManager.newSqlFactory(GimSqlFactoryManager.java:16)
at com.genesyslab.gim.etl.server.AbstractSqlFactoryManager.getSQLFactory(AbstractSqlFactoryManager.java:79)
at com.genesyslab.gim.etl.server.Environment$Configurator.configure(Environment.java:172)
at com.genesyslab.gim.etl.server.JobController.getEnvironment(JobController.java:1252)
at com.genesyslab.gim.etl.server.JobController.doDBCall(JobController.java:537)
at com.genesyslab.gim.etl.server.JobController.load(JobController.java:703)
at com.genesyslab.gim.etl.server.JobController.initialize(JobController.java:714)
at com.genesyslab.gim.etl.server.JobController.initializeOnce(JobController.java:1294)
at com.genesyslab.gim.etl.server.JobController$FsmContext.isInitialized(JobController.java:1022)
at com.genesyslab.gim.etl.server.DefaultScheduler$State$1.next(DefaultScheduler.java:23)
at com.genesyslab.gim.etl.server.DefaultScheduler.run(DefaultScheduler.java:292)
at com.genesyslab.gim.etl.server.JobController.tick(JobController.java:804)
at com.genesyslab.gim.etl.server.GIMServer.doMain(GIMServer.java:441)
at com.genesyslab.gim.etl.server.GIMServer.main(GIMServer.java:472)
Caused by: com.genesyslab.gim.etl.exceptions.UncategorizedSQLException: columnExists; Uncategorized SQLException for SQL [SELECT * FROM ABCD_GIM85.CTL_UD_TO_UDE_MAPPING T WHERE 1 = 0]; SQLSTATE=S0002; error code=208; DBError=UNCATEGORIZED; Invalid object name 'ABCD_GIM85.CTL_UD_TO_UDE_MAPPING'.
at com.genesyslab.gim.etl.exceptions.SQLExceptionTranslator.translate(SQLExceptionTranslator.java:56)
at com.genesyslab.gim.etl.exceptions.SQLExceptionTranslator.translate(SQLExceptionTranslator.java:28)
at com.genesyslab.gim.etl.util.jdbc.SQLUtils.columnExists(SQLUtils.java:2530)
at com.genesyslab.gim.etl.util.jdbc.SQLUtils.columnExists(SQLUtils.java:2508)
at com.genesyslab.gim.etl.dao.JdbcDaoSupport.columnExists(JdbcDaoSupport.java:59)
at com.genesyslab.gim.etl.beans.ctl.CtlUdToUdeMappingDao$Jdbc$1Impl.<init>(CtlUdToUdeMappingDao.java:51)
at com.genesyslab.gim.etl.beans.ctl.CtlUdToUdeMappingDao$Jdbc.load(CtlUdToUdeMappingDao.java:96)
at com.genesyslab.gim.etl.beans.ctl.UdeMapping.<init>(UdeMapping.java:156)
at com.genesyslab.gim.etl.beans.ctl.UdeMapping.getUdeTableNames(UdeMapping.java:110)
at com.genesyslab.gim.etl.beans.ctl.UdeMapping.getUdeFactTableNames(UdeMapping.java:105)
at com.genesyslab.gim.etl.jobs.maintain.PurgeParameters.loadCustomTableNames(PurgeParameters.java:95)
at com.genesyslab.gim.etl.jobs.maintain.PurgeParameters.getAllPurgedTableNamesFilter(PurgeParameters.java:85)
... 15 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ABCD_GIM85.CTL_UD_TO_UDE_MAPPING'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteCursored(SQLServerStatement.java:1853)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:749)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:611)
at com.genesyslab.gim.etl.util.jdbc.SQLUtils.columnExists(SQLUtils.java:2519)
... 24 more
[/code]
-
Maybe make that user a dbo
Enviado de meu E6633 usando Tapatalk
-
He his dbo for that database. (in the user mapping)
His there anywhere else it should be set? I'll check again.
-
I do remember something similar to that in ODS. There was an annex option to be added in DAP.
Enviado de meu E6633 usando Tapatalk
-
Did you set
default-schema=dbo in GIM DAP options?
-
You're absolutely right. It works after adding [b]default-schema = dbo[/b] in gim-etl section of my [b]DAP[/b] !
I feel ashamed, the solution was already on the forum ; :-[ :-[
http://www.sggu.com/smf/index.php?topic=6153.0
edit: Thanks cavagnaro and parshivets.