Error compiling job - Input string too long, limit 8192

csri · Post by **csri** » Tue Jan 20, 2009 10:22 am

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.

chulett · Post by **chulett** » Tue Jan 20, 2009 10:24 am

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

csri · Post by **csri** » Tue Jan 20, 2009 10:28 am

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.

Katie09 · Post by **Katie09** » Tue Jan 20, 2009 10:52 am

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

csri · Post by **csri** » Tue Jan 20, 2009 11:01 am

csri · Post by **csri** » Tue Jan 20, 2009 12:11 pm

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.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 20, 2009 3:19 pm

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