Originally posted by: SystemAdmin

Using Cmgr7.5, W2k Server, Oracle9i.

Installed 75 components, created tables and converted/loaded old Cmgr data to new Cmgr formats etc..., setup registry file with correct paths etc... and pointed mdq file to DB (tested connection etc), Imported X12 Standards DTL and deployed with Wizard.

Two issues.....

1. If I run the export map from Command Server the map completes but no '.tsv' files are created in '\share'.

2. When Export.mmc runs via Event Server it fails, adapter return code = -1027 and map return code = 12. I've confirmed the paths are correct. Log file looks like the variables for Resource Registry are valid.

Any Thoughts?
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

Make sure you can connect to the database outside of TX. If you are using MS SQl - try the enterprise tools, Oracle - SQLplus ect.

Within the Update.mdq - click on the tables icon. If you get the dialog box with the tables listing your connections are ok if not you have a connectivity problem.

Make sure the update.mdq gets placed into the \cmgr\mmgr directory.
Scott Norris

Solutions Architect
Ascential Software Corporation
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Yep did all that.

The runmap is successfull via Command Server (resolved path issue for tsv files) but unsuccessfull via Event Server. Here's the dbl file created by trace

<988-356>: Validating the adapter command...
<988-356>: Database type is Oracle
<988-1172>: Connecting...
<988-1172>: Returned status: (-1027) Failed to load DLL
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Results of the Command Server run investigated... everything in the Refresh.tsv was successfull except:

Save Old POs - putas.mmc : 12

I also noted that the Msg_Mgr.MSD had some references to 6.7 and 6.5 which aren't installed on this box. I checked Windows Registry and there is no ref to them there.

Could there be an install order issue or an issue in the DB that needs to be addressed?
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender