DSXchange

Hi,

I am running into an error while compiling a server job. Here are the details.

Source: Oracle table
Target: Access database table
Transformer: maps source fields to target fields

Oracle stage (Source) ------> Transformer----------->ODBC stage (MS Access)

When I compile the job, I am getting the following error:

"Compiling: Source = 'RT_BP1145/JOB.1546223192.DT.1499637778.TRANS1', Object = 'RT_BP1145.O/JOB.1546223192.DT.1499637778.TRANS1'
****************************************************************************************************************************??Input string too long, limit 8192
(ABC_load_curr_year_data_to_access.Transformer_1)"

Any suggestions or help is appreciated.

Thank you guys.

"Input string too long, limit 8192". What are you doing in the transformer? Any large derivations or large character fields?

There are no derivations in the transformer. There are about 53 fields that are mapped from source to target. Names of some of the fields are large too.

Whether the columns names u r having more than 8192 characters..??

No.

Total length of field names of all the 53 target fields is 1491 and max length of field name used for one of the fields is 47.

Any inputs appreciated.

Please post the contents of the file RT_BP1145/JOB.1546223192.DT.1499637778.TRANS1 (encased in Code tags).