I am facing a strange error/warning. I am getting task error as "WARNING. MATCH FIELDS HAVE SAME NAME BUT DIFFERENT FORMATS:" in our production report caster, whereas identical report in Non prod reportcaster is running fine without any error. Even when I run the report directly from dev studio everything seems to be fine.

I have issued ?FF to all the hold file used in the MATCH command to find field format and name but everything is identical.

I don't want to add warning number in report caster ignore error configuration list, until I know the answer for WHY I am getting this error only in one environemnt......


Please help me how to trace the root cause.

7.6.11
Linux
Excel output

This message has been edited. Last edited by: krish,

Check to make sure you don't have any other master files with the same name in the app path.

I have checked all the master file in my app path we don't have any existing master file with the same name.

I am using MATCH command issued against the hold file created in that session.

This message has been edited. Last edited by: krish,

This might be a result of the data in the tables.

Can you please post your code?

I am pretty sure this issue is not related to data its more close to environment as from nonProd WebFOCUS environment I have connected the Prod database and ran the same report, it ran fine.

In Prod environment with the same Prod database environment we are getting error.

By the way this error is happening for multiple report close to 10 different reports.

In sistory these reports were running fine.

Well, if this is a classic "nobody has done anything", try refreshing the non-prod masterfile causing the error. Then refresh the production masterfile. either you start getting the same error in non-prod or then you see what it is getting grumpy about.

You may want to run CHECK FILE HOLD and the corresponding TABLE FILE command to see what it actually thinks the formats are. A WHENCE statement will prove that it getting the master from where you think as well.

Fernando

I second Fernando's advice.

Try to keep the Hold file names unique to each procedure file. A naming convention that includes a unique number in each fex name helps make that doable.

issue is somehow
varchar is ON for Report caster execution its creating variable alpha datatype, after issuing below command in Server profile
ENGINE DB2 SET VARCHAR OFF

we get rid of the error.

Thanks every one for your help!!