May 05, 2008, 11:23 AM
Luiz De Assiserror Reporting Server messages exceeded IBIF_max_messages
Hello!
I'm getting the error above when trying to create a hold file (format FOCUS) using a csv file with 11 columns. My csv file has about 34000 records. I've created a master for the csv file. Any suggestions on what might be causing the error, and how to fix it? Thanks
Luiz
FILENAME=BTNBDEBT, SUFFIX=COMT ,
DATASET=e:\ibi\apps\dtv\BTNBDEBT.csv, $
SEGMENT=BTNBDEBT, SEGTYPE=S0, $
FIELDNAME=BTN, ALIAS=E01 , USAGE=A13V, ACTUAL=A13V, $
FIELDNAME=STATE, ALIAS=E02, USAGE=A5V, ACTUAL=A5V, $
FIELDNAME=CUST_CD, ALIAS=E03 , USAGE=A10V, ACTUAL=A10V, , $
FIELDNAME=NAME, ALIAS=E04 , USAGE=A100V, ACTUAL=A100V, $
FIELDNAME=BRC, ALIAS=E05 , USAGE=A2V, ACTUAL=A2V, $
FIELDNAME=ACCT_ENT_WO, ALIAS=E06 , USAGE=A8V, ACTUAL=A8V, $
FIELDNAME=WO_AMT, ALIAS=E07 , USAGE=D12.2, ACTUAL=D12.2, $
FIELDNAME=DISC_DAT, ALIAS=E08 , USAGE=A6V, ACTUAL=A6V, $
FIELDNAME=BO_WO_DAT, ALIAS=E09 , USAGE=A6V, ACTUAL=A6V, $
FIELDNAME=GL_WO_DAT, ALIAS=E10 , USAGE=A6V, ACTUAL=A6V, $
FIELDNAME=DUPS2, ALIAS=E11 , USAGE=A4V, ACTUAL=A4V, $
FIELDNAME=STANDALONE, ALIAS=E12 , USAGE=A2V, ACTUAL=A2V, $
May 05, 2008, 11:54 AM
GinnyJakesPut a READLIMIT in your request to minimize the number of errors you are getting so that you can see what the error is. We can't fix the error until we know what it is.
Also, please update your signature profile with your list of products, releases, and platforms so that we can better help you.
May 05, 2008, 12:17 PM
Danny-SRLLuiz,
Two comments about your MASTER file:
1. Since you have a csv file, the ACTUAL formats can only be A. See the ACTUAL of WO_AMT: it cannot be D12.2.
2. I would never use the AnV formats for a csv file.
May 05, 2008, 06:52 PM
Luiz De AssisThank you Danny & Ginny! I was able to get it to work by removing some of the fields from the master file, and the actual csv file. I'll keep in mind the READLIMIT, and the ACTUAL format for csv files. Appreciate it.
Luiz
May 06, 2008, 07:20 PM
WazI agree with Danny
Always have the ACUTAL as Annn
and there should be no reason to use Varchars.
May 07, 2008, 11:52 AM
smithsLooks like Danny has solved the root of your problem.
As an aside, I had this error previously also, and to avoid it, I set the value for IBIF_max_messages to 0 in the client settings. This can be updated from the WF Administration Console (http://server_name/ibi_html/wfconsole.htm), under Configuration->Client Settings->General. You must log in with an account at the Administrator Level.
Setting the value to 0 means that there is no limit for the number of error messages. I don't know if there are any side-effects with doing this, but I haven't seen any in 3+ months.
Sean
May 07, 2008, 05:28 PM
WazThe side effects i've found is when a large number of line of output are returned, it can cause your browser problems.