CA WA AE (AutoSys) PeopleSoft Adapter v2.1.0 job fails with Exit Code 233. The Adapter debug log shows: ERROR: MSG = [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

Document ID:  TEC1082999
Last Modified Date:  03/22/2016
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • Unicenter Job Management for ERP Applications

Releases

  • Unicenter Job Management for ERP Applications:Release:2.1.0

Components

  • Unicenter AutoSys Adapter for PeopleSoft:ATSYAP

Issue:

CA WA AE (AutoSys) PeopleSoft Adapter v2.1.0 job fails with exit code 233.
The PS Adapter debug job log shows:

PeopleSoft(30)->ODBC_err: ERROR: SQLSTATE = IM014
PeopleSoft(31)->ODBC_err: ERROR: NATIVE ERROR = 0
PeopleSoft(32)->ODBC_err: ERROR: MSG = [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

PeopleSoft(33)->psoft_exit: debug: psoft_exit
[233]
    A database error has occurred.

Environment:

CA WA AE (AutoSys) PeopleSoft Adapter v2.1.0 on Windows OS x64 bit

Cause:

  1. The aforementioned ODBC error manifests when a 32bit application attempts to connect to the intended database (MS SQL Server, Oracle, Sybase) using a 64-bit ODBC System DSN.
  2. On 64bit Windows OS, the default Windows ODBC Data Source Administrator [Start-> Administrative Tools -> Data Sources (ODBC)] creates a 64 bit data source.
  3. The WA AE (AutoSys) PeopleSoft Adapter v2.1.0 is a 32bit application and hence, on a 64-bit Windows OS, the ODBC System DSN datasource must be created using the Windows 32-bit ODBC Administrator tool: %SYSTEMROOT%\SysWOW64\odbcad32.exe

Resolution:

  1. Delete the ODBC System DSN data source using the 64bit ODBC Data Source Administrator (Start-> Administrative Tools -> Data Sources (ODBC))
  2. Create the ODBC System DSN using 32bit Windows ODBC Data Source Administrator tool:

C:\Windows\SysWOW64\odbcad32.exe

Note:

The Data Source Name will be entered in a PS Adapter configuration file (.cfg) under %AUTOUSER% as the value for PSOFT_ODBC parameter. If an incorrect Data Source name is specified against PSOFT_ODBC, the following error manifests:

PeopleSoft(30)->ODBC_err: ERROR: SQLSTATE = IM002
PeopleSoft(31)->ODBC_err: ERROR: NATIVE ERROR = 0
PeopleSoft(32)->ODBC_err: ERROR: MSG = [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

PeopleSoft(33)->psoft_exit: debug: psoft_exit
[233]
A database error has occurred.

Additional Information:

To run an application as a 32-bit application on a 64-bit operating system, you must create the ODBC data source with the ODBC Administrator in %windir%\SysWOW64\odbcad32.exe.

A 64-bit Windows operating system has two odbcad32.exe files:

  • %SystemRoot%\system32\odbcad32.exe is used to create and maintain data source names for 64-bit applications.
  • %SystemRoot%\SysWOW64\odbcad32.exe is used to create and maintain data source names for 32-bit applications, including 32-bit applications that run on 64-bit operating systems.

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >