Troubleshooting
Problem
When attempting to use the Planning Analytics (and TM1) Decision Optimization (DO) Connector, the Run Optimization TI Process throws errors in the <DO-TM1_Connector>\connector.log file
Resolving The Problem
------------------
Error:
2019-09-04 16:48:59,785 ERROR [main] com.ibm.wrapper.util.AESencrypt: d:\Gas\Gas\DO-TM1_Connector\.\files\key (The system cannot find the path specified.)
2019-09-04 16:48:59,786 ERROR [main] com.ibm.wrapper.util.AESencrypt: Key file or password file does not exist at the given locations.
2019-09-04 16:48:59,789 ERROR [main] stderr: Exception in thread "main"
2019-09-04 16:48:59,789 ERROR [main] stderr: java.lang.RuntimeException: Could not find one of key file d:\Gas\Gas\DO-TM1_Connector\./files/key and encrypted file d:\Gas\Gas\DO-TM1_Connector\./files/tm1
2019-09-04 16:48:59,789 ERROR [main] stderr: at com.ibm.wrapper.util.AESencrypt.readEncryptedFile(Unknown Source)
2019-09-04 16:48:59,789 ERROR [main] stderr: at com.ibm.wrapper.util.AESencrypt.decryptData(Unknown Source)
2019-09-04 16:48:59,789 ERROR [main] stderr: at com.ibm.wrapper.util.DOUserEncrypt.getCredentials(Unknown Source)
2019-09-04 16:48:59,789 ERROR [main] stderr: at com.ibm.wrapper.service.MainConstants.initiatePropertiesAndCredentials(Unknown Source)
2019-09-04 16:48:59,789 ERROR [main] stderr: at com.ibm.wrapper.service.MainConstants.parseArgs(Unknown Source)
2019-09-04 16:48:59,790 ERROR [main] stderr: at com.ibm.wrapper.service.Service.main(Unknown Source)
2019-09-04 16:48:59,786 ERROR [main] com.ibm.wrapper.util.AESencrypt: Key file or password file does not exist at the given locations.
2019-09-04 16:48:59,789 ERROR [main] stderr: Exception in thread "main"
2019-09-04 16:48:59,789 ERROR [main] stderr: java.lang.RuntimeException: Could not find one of key file d:\Gas\Gas\DO-TM1_Connector\./files/key and encrypted file d:\Gas\Gas\DO-TM1_Connector\./files/tm1
2019-09-04 16:48:59,789 ERROR [main] stderr: at com.ibm.wrapper.util.AESencrypt.readEncryptedFile(Unknown Source)
2019-09-04 16:48:59,789 ERROR [main] stderr: at com.ibm.wrapper.util.AESencrypt.decryptData(Unknown Source)
2019-09-04 16:48:59,789 ERROR [main] stderr: at com.ibm.wrapper.util.DOUserEncrypt.getCredentials(Unknown Source)
2019-09-04 16:48:59,789 ERROR [main] stderr: at com.ibm.wrapper.service.MainConstants.initiatePropertiesAndCredentials(Unknown Source)
2019-09-04 16:48:59,789 ERROR [main] stderr: at com.ibm.wrapper.service.MainConstants.parseArgs(Unknown Source)
2019-09-04 16:48:59,790 ERROR [main] stderr: at com.ibm.wrapper.service.Service.main(Unknown Source)
Resolution:
-Open TM1 Architect/Performance Modeler and connect to your PA/TM1 Server
-Execute the Encrypt Credentials TI Process
-When prompted, the PA/TM1 password is mandatory
*The DO Cloud API key is required only if using DO Cloud. Otherwise leave empty.
------------------
Error:
2019-09-05 11:25:13,129 FATAL [main] com.ibm.wrapper.util.WrapperProperties: Property <api.url> is not set in property-file <d:\Gas\Gas\DO-TM1_Connector\config/connector.properties>
2019-09-05 11:25:13,133 ERROR [main] stderr: Exception in thread "main"
2019-09-05 11:25:13,133 ERROR [main] stderr: java.lang.ExceptionInInitializerError
2019-09-05 11:25:13,133 ERROR [main] stderr: at java.lang.J9VMInternals.ensureError(J9VMInternals.java:148)
2019-09-05 11:25:13,133 ERROR [main] stderr: at java.lang.J9VMInternals.recordInitializationFailure(J9VMInternals.java:137)
2019-09-05 11:25:13,133 ERROR [main] stderr: at com.ibm.wrapper.util.DOUserEncrypt.getCredentials(Unknown Source)
2019-09-05 11:25:13,133 ERROR [main] stderr: at com.ibm.wrapper.service.MainConstants.initiatePropertiesAndCredentials(Unknown Source)
2019-09-05 11:25:13,133 ERROR [main] stderr: at com.ibm.wrapper.service.MainConstants.parseArgs(Unknown Source)
2019-09-05 11:25:13,134 ERROR [main] stderr: at com.ibm.wrapper.service.Service.main(Unknown Source)
2019-09-05 11:25:13,134 ERROR [main] stderr: Caused by:
2019-09-05 11:25:13,134 ERROR [main] stderr: java.lang.RuntimeException: Property <api.url> is not set in property-file <d:\Gas\Gas\DO-TM1_Connector\config/connector.properties>
2019-09-05 11:25:13,134 ERROR [main] stderr: at com.ibm.wrapper.util.WrapperProperties.throwAndLogRuntimeException(Unknown Source)
2019-09-05 11:25:13,134 ERROR [main] stderr: at com.ibm.wrapper.util.WrapperProperties.getProperty(Unknown Source)
2019-09-05 11:25:13,134 ERROR [main] stderr: at com.ibm.wrapper.util.Constants.<clinit>(Unknown Source)
2019-09-05 11:25:13,134 ERROR [main] stderr: ... 4 more
2019-09-05 11:25:13,133 ERROR [main] stderr: Exception in thread "main"
2019-09-05 11:25:13,133 ERROR [main] stderr: java.lang.ExceptionInInitializerError
2019-09-05 11:25:13,133 ERROR [main] stderr: at java.lang.J9VMInternals.ensureError(J9VMInternals.java:148)
2019-09-05 11:25:13,133 ERROR [main] stderr: at java.lang.J9VMInternals.recordInitializationFailure(J9VMInternals.java:137)
2019-09-05 11:25:13,133 ERROR [main] stderr: at com.ibm.wrapper.util.DOUserEncrypt.getCredentials(Unknown Source)
2019-09-05 11:25:13,133 ERROR [main] stderr: at com.ibm.wrapper.service.MainConstants.initiatePropertiesAndCredentials(Unknown Source)
2019-09-05 11:25:13,133 ERROR [main] stderr: at com.ibm.wrapper.service.MainConstants.parseArgs(Unknown Source)
2019-09-05 11:25:13,134 ERROR [main] stderr: at com.ibm.wrapper.service.Service.main(Unknown Source)
2019-09-05 11:25:13,134 ERROR [main] stderr: Caused by:
2019-09-05 11:25:13,134 ERROR [main] stderr: java.lang.RuntimeException: Property <api.url> is not set in property-file <d:\Gas\Gas\DO-TM1_Connector\config/connector.properties>
2019-09-05 11:25:13,134 ERROR [main] stderr: at com.ibm.wrapper.util.WrapperProperties.throwAndLogRuntimeException(Unknown Source)
2019-09-05 11:25:13,134 ERROR [main] stderr: at com.ibm.wrapper.util.WrapperProperties.getProperty(Unknown Source)
2019-09-05 11:25:13,134 ERROR [main] stderr: at com.ibm.wrapper.util.Constants.<clinit>(Unknown Source)
2019-09-05 11:25:13,134 ERROR [main] stderr: ... 4 more
Resolution:
-Open/edit the <DO-TM1_Connector>\config\connector.properties file
-Open/edit the <DO-TM1_Connector>\config\connector.properties file
-Add the following parameter:value to the file: api.url=http://api-oaas.docloud.ibmcloud.com/job_manager/rest/v1/jobs/
------------------
Error:
2019-09-05 11:32:29,551 INFO [main] com.ibm.wrapper.service.MainConstants: Initiated properties.
2019-09-05 11:32:29,551 INFO [main] com.ibm.wrapper.service.MainConstants: Set string arguments.
2019-09-05 11:32:29,551 INFO [main] com.ibm.wrapper.service.Service: Start Optimization
2019-09-05 11:32:29,564 INFO [main] com.ibm.wrapper.tm1.View: Setting up view DO-TM1 Control for cube DO-TM1 Control
2019-09-05 11:32:29,574 DEBUG [main] stdout: Setting the auth type to be 0 for server TM1 Admin Server
2019-09-05 11:32:29,575 DEBUG [main] com.ibm.wrapper.http_methods.Server: Base address: http://localhost:5000
2019-09-05 11:32:29,882 ERROR [main] com.ibm.wrapper.http_methods.OdataUtils: Issue converting response content to JsonNode?
2019-09-05 11:32:29,882 DEBUG [main] com.ibm.wrapper.http_methods.Server: Base address: http://localhost:0
2019-09-05 11:32:29,906 INFO [main] com.ibm.wrapper.service.Service: Caught exception
2019-09-05 11:32:29,906 INFO [main] com.ibm.wrapper.service.Service: Class: class java.lang.ArrayIndexOutOfBoundsException
2019-09-05 11:32:29,906 ERROR [main] com.ibm.wrapper.service.Service: Array index out of range: 0
2019-09-05 11:32:29,906 ERROR [main] com.ibm.wrapper.http_methods.OdataUtils: Issue converting response content to JsonNode?
2019-09-05 11:32:29,908 ERROR [main] com.ibm.wrapper.service.Service: Error setting Connector Run Status value in DO-TM1 Control cube
2019-09-05 11:32:29,923 INFO [main] com.ibm.wrapper.service.Service: Time elapsed: 0 seconds.
2019-09-05 11:32:29,551 INFO [main] com.ibm.wrapper.service.MainConstants: Set string arguments.
2019-09-05 11:32:29,551 INFO [main] com.ibm.wrapper.service.Service: Start Optimization
2019-09-05 11:32:29,564 INFO [main] com.ibm.wrapper.tm1.View: Setting up view DO-TM1 Control for cube DO-TM1 Control
2019-09-05 11:32:29,574 DEBUG [main] stdout: Setting the auth type to be 0 for server TM1 Admin Server
2019-09-05 11:32:29,575 DEBUG [main] com.ibm.wrapper.http_methods.Server: Base address: http://localhost:5000
2019-09-05 11:32:29,882 ERROR [main] com.ibm.wrapper.http_methods.OdataUtils: Issue converting response content to JsonNode?
2019-09-05 11:32:29,882 DEBUG [main] com.ibm.wrapper.http_methods.Server: Base address: http://localhost:0
2019-09-05 11:32:29,906 INFO [main] com.ibm.wrapper.service.Service: Caught exception
2019-09-05 11:32:29,906 INFO [main] com.ibm.wrapper.service.Service: Class: class java.lang.ArrayIndexOutOfBoundsException
2019-09-05 11:32:29,906 ERROR [main] com.ibm.wrapper.service.Service: Array index out of range: 0
2019-09-05 11:32:29,906 ERROR [main] com.ibm.wrapper.http_methods.OdataUtils: Issue converting response content to JsonNode?
2019-09-05 11:32:29,908 ERROR [main] com.ibm.wrapper.service.Service: Error setting Connector Run Status value in DO-TM1 Control cube
2019-09-05 11:32:29,923 INFO [main] com.ibm.wrapper.service.Service: Time elapsed: 0 seconds.
Resolution:
-Open/edit the <DO-TM1_Connector>\config\connector.properties file
-Verify that the tm1.adminhost, tm1.adminPort, and tm1.adminSSL parameters contain the correct values for your TM1 Admin Server
-With SSL default example:
tm1.adminhost=localhost
tm1.adminhost=localhost
tm1.adminPort=5898
tm1.adminSSL=T
-Without SSL default example:
tm1.adminhost=localhost
tm1.adminhost=localhost
tm1.adminPort=5895
tm1.adminSSL=F
------------------
Error:
2019-09-09 14:13:01,373 INFO [main] com.ibm.wrapper.service.MainConstants: Initiated properties.
2019-09-09 14:13:01,373 INFO [main] com.ibm.wrapper.service.MainConstants: Set string arguments.
2019-09-09 14:13:01,373 INFO [main] com.ibm.wrapper.service.Service: Start Optimization
2019-09-09 14:13:01,374 INFO [main] com.ibm.wrapper.tm1.View: Setting up view DO-TM1 Control for cube DO-TM1 Control
2019-09-09 14:13:01,377 DEBUG [main] stdout: Setting the auth type to be 0 for server TM1 Admin Server
2019-09-09 14:13:01,378 DEBUG [main] com.ibm.wrapper.http_methods.Server: Base address: http://localhost:5895
2019-09-09 14:13:01,700 ERROR [main] com.ibm.wrapper.http_methods.OdataUtils: "'Gas_Example' can not be found in collection of type 'Server'."
2019-09-09 14:13:01,700 ERROR [main] com.ibm.wrapper.http_methods.OdataUtils: Issue converting response content to JsonNode?
2019-09-09 14:13:01,700 DEBUG [main] com.ibm.wrapper.http_methods.Server: Base address: http://localhost:0
2019-09-09 14:13:01,702 INFO [main] com.ibm.wrapper.service.Service: Caught exception
2019-09-09 14:13:01,702 INFO [main] com.ibm.wrapper.service.Service: Class: class java.lang.ArrayIndexOutOfBoundsException
2019-09-09 14:13:01,702 ERROR [main] com.ibm.wrapper.service.Service: Array index out of range: 0
2019-09-09 14:13:01,704 ERROR [main] com.ibm.wrapper.http_methods.OdataUtils: "'Gas_Example' can not be found in collection of type 'Server'."
2019-09-09 14:13:01,704 ERROR [main] com.ibm.wrapper.http_methods.OdataUtils: Issue converting response content to JsonNode?
2019-09-09 14:13:01,705 ERROR [main] com.ibm.wrapper.service.Service: Error setting Connector Run Status value in DO-TM1 Control cube
2019-09-09 14:13:01,709 INFO [main] com.ibm.wrapper.service.Service: Time elapsed: 0 seconds.
2019-09-09 14:13:01,373 INFO [main] com.ibm.wrapper.service.MainConstants: Set string arguments.
2019-09-09 14:13:01,373 INFO [main] com.ibm.wrapper.service.Service: Start Optimization
2019-09-09 14:13:01,374 INFO [main] com.ibm.wrapper.tm1.View: Setting up view DO-TM1 Control for cube DO-TM1 Control
2019-09-09 14:13:01,377 DEBUG [main] stdout: Setting the auth type to be 0 for server TM1 Admin Server
2019-09-09 14:13:01,378 DEBUG [main] com.ibm.wrapper.http_methods.Server: Base address: http://localhost:5895
2019-09-09 14:13:01,700 ERROR [main] com.ibm.wrapper.http_methods.OdataUtils: "'Gas_Example' can not be found in collection of type 'Server'."
2019-09-09 14:13:01,700 ERROR [main] com.ibm.wrapper.http_methods.OdataUtils: Issue converting response content to JsonNode?
2019-09-09 14:13:01,700 DEBUG [main] com.ibm.wrapper.http_methods.Server: Base address: http://localhost:0
2019-09-09 14:13:01,702 INFO [main] com.ibm.wrapper.service.Service: Caught exception
2019-09-09 14:13:01,702 INFO [main] com.ibm.wrapper.service.Service: Class: class java.lang.ArrayIndexOutOfBoundsException
2019-09-09 14:13:01,702 ERROR [main] com.ibm.wrapper.service.Service: Array index out of range: 0
2019-09-09 14:13:01,704 ERROR [main] com.ibm.wrapper.http_methods.OdataUtils: "'Gas_Example' can not be found in collection of type 'Server'."
2019-09-09 14:13:01,704 ERROR [main] com.ibm.wrapper.http_methods.OdataUtils: Issue converting response content to JsonNode?
2019-09-09 14:13:01,705 ERROR [main] com.ibm.wrapper.service.Service: Error setting Connector Run Status value in DO-TM1 Control cube
2019-09-09 14:13:01,709 INFO [main] com.ibm.wrapper.service.Service: Time elapsed: 0 seconds.
Resolution:
-Open TM1 Architect/Performance Modeler and connect to your PA/TM1 Server
-Open the Connector TM1 Server Information cube
-Update the cube Server Name with the TM1 Server Name you wish to connect to
------------------
Error:
2019-09-09 14:18:16,500 INFO [main] com.ibm.wrapper.service.MainConstants: Initiated properties.
2019-09-09 14:18:16,501 INFO [main] com.ibm.wrapper.service.MainConstants: Set string arguments.
2019-09-09 14:18:16,501 INFO [main] com.ibm.wrapper.service.Service: Start Optimization
2019-09-09 14:18:16,501 INFO [main] com.ibm.wrapper.tm1.View: Setting up view DO-TM1 Control for cube DO-TM1 Control
2019-09-09 14:18:16,504 DEBUG [main] stdout: Setting the auth type to be 0 for server TM1 Admin Server
2019-09-09 14:18:16,505 DEBUG [main] com.ibm.wrapper.http_methods.Server: Base address: http://localhost:5895
2019-09-09 14:18:16,772 DEBUG [main] com.ibm.wrapper.http_methods.Server: Base address: http://localhost:5000
2019-09-09 14:18:16,776 DEBUG [main] stdout: Setting the auth type to be 5 for server Gas
2019-09-09 14:18:17,803 ERROR [main] com.ibm.wrapper.http_methods.OdataUtils: Unauthorized access to TM1
2019-09-09 14:18:17,803 INFO [main] com.ibm.wrapper.service.Service: Caught exception
2019-09-09 14:18:17,803 INFO [main] com.ibm.wrapper.service.Service: Class: class java.lang.RuntimeException
2019-09-09 14:18:17,803 ERROR [main] com.ibm.wrapper.service.Service: Please check username and password for TM1.
2019-09-09 14:18:17,803 ERROR [main] com.ibm.wrapper.http_methods.OdataUtils: Unauthorized access to TM1
2019-09-09 14:18:17,803 ERROR [main] com.ibm.wrapper.service.Service: Error setting Connector Run Status value in DO-TM1 Control cube
2019-09-09 14:18:17,807 INFO [main] com.ibm.wrapper.service.Service: Time elapsed: 1 seconds.
2019-09-09 14:18:16,501 INFO [main] com.ibm.wrapper.service.MainConstants: Set string arguments.
2019-09-09 14:18:16,501 INFO [main] com.ibm.wrapper.service.Service: Start Optimization
2019-09-09 14:18:16,501 INFO [main] com.ibm.wrapper.tm1.View: Setting up view DO-TM1 Control for cube DO-TM1 Control
2019-09-09 14:18:16,504 DEBUG [main] stdout: Setting the auth type to be 0 for server TM1 Admin Server
2019-09-09 14:18:16,505 DEBUG [main] com.ibm.wrapper.http_methods.Server: Base address: http://localhost:5895
2019-09-09 14:18:16,772 DEBUG [main] com.ibm.wrapper.http_methods.Server: Base address: http://localhost:5000
2019-09-09 14:18:16,776 DEBUG [main] stdout: Setting the auth type to be 5 for server Gas
2019-09-09 14:18:17,803 ERROR [main] com.ibm.wrapper.http_methods.OdataUtils: Unauthorized access to TM1
2019-09-09 14:18:17,803 INFO [main] com.ibm.wrapper.service.Service: Caught exception
2019-09-09 14:18:17,803 INFO [main] com.ibm.wrapper.service.Service: Class: class java.lang.RuntimeException
2019-09-09 14:18:17,803 ERROR [main] com.ibm.wrapper.service.Service: Please check username and password for TM1.
2019-09-09 14:18:17,803 ERROR [main] com.ibm.wrapper.http_methods.OdataUtils: Unauthorized access to TM1
2019-09-09 14:18:17,803 ERROR [main] com.ibm.wrapper.service.Service: Error setting Connector Run Status value in DO-TM1 Control cube
2019-09-09 14:18:17,807 INFO [main] com.ibm.wrapper.service.Service: Time elapsed: 1 seconds.
Resolution:
-Open TM1 Architect/Performance Modeler and connect to your PA/TM1 Server
-Open the Connector TM1 Server Information cube
-Update the cube TM1 User Name with the User Name you wish to connect with
*If using CAM Security
-Open/edit the <DO-TM1_Connector>\config\connector.properties file
-Ensure the cam.namespace parameter has been set and accurately reflects your CAM Namespace ID
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
10 September 2019
UID
ibm11073382