Hi Ed et al,
Like Barbara mentioned before, Optim classical GUI just stalls and causes the server crash after some time.
We have tried to run (extract process which runs all right locally btw) service via Optim Designer and Optim revealed a bit more info lines in log file.
Would you mind taking a look at our configuration (below) in Linux? Optim Server doesn't find anything wrong with pstserv.cfg when we run
pr0svce -v pstserv.cfg
to validate
Yet we experience below whilst
Running batch in Optim designer – error in log
Apr 17, 2019 3:40:56 PM org.apache.commons.httpclient.SimpleHttpConnectionManager getConnectionWithTimeout
WARNING: SimpleHttpConnectionManager being used incorrectly. Be sure that HttpMethod.releaseConnection() is always called and that only one thread and/or method is using this connection manager at a time.
Apr 17, 2019 3:40:56 PM org.apache.commons.httpclient.HttpMethodDirector isRedirectNeeded
INFO: Redirect requested but followRedirects is disabled
Apr 17, 2019 3:40:56 PM org.apache.commons.httpclient.SimpleHttpConnectionManager getConnectionWithTimeout
WARNING: SimpleHttpConnectionManager being used incorrectly. Be sure that HttpMethod.releaseConnection() is always called and that only one thread and/or method is using this connection manager at a time.
Apr 17, 2019 3:41:39 PM com.ibm.nex.core.util.logging.AbstractLoggable info
INFO: Launching Service Execution Monitor job...
Apr 17, 2019 3:41:39 PM com.ibm.nex.core.util.logging.AbstractLoggable info
INFO: Dispatching service with execution id '466bc48c-1c2b-4a76-8ed9-045d44d48c4b'
Apr 17, 2019 3:41:40 PM com.ibm.nex.core.util.logging.AbstractLoggable info
INFO: Setting working directory to %s/opt/IBM/InfoSphere/Optim/rsiwork
Apr 17, 2019 3:41:40 PM com.ibm.nex.core.util.logging.AbstractLoggable info
INFO: Launching pr0cmnd for run...
Apr 17, 2019 3:41:40 PM com.ibm.nex.core.util.logging.AbstractLoggable info
INFO: Launching 'pr0cmnd -R TYPE=EXTRACT REQUEST=MSADDR.ALL DIRECTORY=OPTIMDIR QUIET+ MONITOR- INSTANCE_ID=466BC48C-1C2B-4A76-8ED9-045D44D48C4B OUTPUT=/opt/IBM/InfoSphere/Optim/rsiwork/466bc48c-1c2b-4a76-8ed9-045d44d48c4b/run.log'.
Apr 17, 2019 3:41:40 PM com.ibm.nex.core.util.logging.AbstractLoggable info
INFO: Pr0cmnd process '466bc48c-1c2b-4a76-8ed9-045d44d48c4b' started
Apr 17, 2019 3:41:40 PM com.ibm.nex.core.util.logging.AbstractLoggable info
INFO: No valid PST Directories have been specified
Apr 17, 2019 3:41:40 PM com.ibm.nex.core.util.logging.AbstractLoggable info
INFO: No valid DB Aliases have been specified
Apr 17, 2019 3:41:41 PM com.ibm.nex.core.util.logging.AbstractLoggable info
INFO: Pr0cmnd process '466bc48c-1c2b-4a76-8ed9-045d44d48c4b' for job '466bc48c-1c2b-4a76-8ed9-045d44d48c4b' ended with return code 28
I am not quite sure since I couldnt find ERRORLEVEL 28 in KC but this is the closest I got to
- RETURN CODE 28
- Cannot load pstlocal.cfg. (See the Installation and Configuration Guide for more information.)
NB: We haven't set up pstlocal.cfg yet. I don't understand why it is needed if we aren't going to run from Linux Server any CLI to run optim jobs.
Anyhow here you are...
rtsetenv
ODBCINI=/opt/IBM/InfoSphere/Optim/rt/bin/odbc.ini
export ODBCINI
pstserv.cfg
dbalias OPTIMDIR MSAW_SQL83 MSAW_SQL83 SVC_xxxxxxx "dLU@xxxxxxxxxxxx"
odbc.ini
MSAW_SQL83=IBM 7.1 SQL Server Wire Protocol
[MSAW_SQL83]
Driver=/opt/IBM/InfoSphere/Optim/rt/bin/OOsqls27.so
Description=IBM 7.1 SQL Server Wire Protocol
AlternateServers=
AlwaysReportTriggerResults=0
AnsiNPW=1
ApplicationName=
ApplicationUsingThreads=1
AuthenticationMethod=1
BulkBinaryThreshold=32
BulkCharacterThreshold=-1
BulkLoadBatchSize=1024
BulkLoadFieldDelimiter=
BulkLoadOptions=2
BulkLoadRecordDelimiter=
ConnectionReset=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=MSAdventureWorks
EnableBulkLoad=0
EnableQuotedIdentifiers=0
EncryptionMethod=0
FailoverGranularity=0
FailoverMode=0
FailoverPreconnect=0
FetchTSWTZasTimestamp=0
FetchTWFSasTime=1
GSSClient=native
HostName=wscxxxxx.subdomain.domain
HostNameInCertificate=
InitializationString=
Language=
LoadBalanceTimeout=0
LoadBalancing=0
LoginTimeout=15
LogonID=SVC_xxxxxxx
MaxPoolSize=100
MinPoolSize=0
PacketSize=-1
Password=dLU@xxxxxxxxxxxx
Pooling=0
PortNumber=1433
QueryTimeout=0
ReportCodePageConversionErrors=0
SnapshotSerializable=0
TrustStore=
TrustStorePassword=
ValidateServerCertificate=1
WorkStationID=
XMLDescribeType=-10
PS: I've checked by listing dynamic dependencies ($>ldd) and everything is alright for OOsqls27.so
# ./testodbc MSAW_SQL83
Enter the data source name : MSAW_SQL83
Enter the user name : SVC_optim_db
Enter the user password :
SQLConnectW returned: 1
Connection successful
Regards,
Ozgur
------------------------------
Ozgur Gul
------------------------------
Original Message:
Sent: Fri April 12, 2019 07:37 AM
From: Ed Lipson
Subject: Optim Server on Linux connecting to SQLServer Data Source using Data Direct drivers
We are using what IBM shipped to us, not any other third party product.
Thanks,
Ed Lipson
Director
BNY Mellon | 2 Hanson Pl AIM 111-0800 | Brooklyn NY 11217
Information Lifecycle Management
T 718.315.4763 | F 724.540.6622 | C 917.859.5180 | ed.lipson@bnymellon.com
The information contained in this e-mail, and any attachment, is confidential and is intended solely for the use of the intended recipient. Access, copying or re-use of the e-mail or any attachment, or any information contained therein, by any other person is not authorized. If you are not the intended recipient please return the e-mail to the sender and delete it from your computer. Although we attempt to sweep e-mail and attachments for viruses, we do not guarantee that either are virus-free and accept no liability for any damage sustained as a result of viruses.
Please refer to
https://disclaimer.bnymellon.com/eu.htm for certain disclosures relating to European legal entities. We take our data protection and privacy responsibilities seriously and our privacy notice explains how we collect, use and share personal information in the course of our business activities. It can be accessed at the privacy section of
www.bnymellon.com.
Original Message------
Hi Ed,
Have you used DataDirect ODBC drivers for MS SQL server shipped with Optim Server or have you bought (Progress) DataDirect ODBC drivers (SQL Server ODBC Driver for Linux | Tutorial ) separately?
If former, is there any interface to connect DSN and fetch data from command line shipped with Optim Server on Linux (before designing extract process)?
I know there is a connection testing utility called testODBC (??) but it returns only whether odbc.ini is successful or not.
Thanks in advance,
Ozgur
------------------------------
Ozgur Gul
------------------------------
#InfoSphereOptim
#Optim