I have been wrestling with this error for several months and can not figure out what is happening.
I am on build 4866 using IIS and I have 3 reports that randomly trigger the following error:
Report did not print. Error reported was:
Layout name: C:\inetpub\Default Web Site\ContractPrint.a5rpt Layout type: report
create_table(tempfilename,tableStructure)=.f.: Too few parameters at line: 552
I have not been able to identify the pattern of the error as it is reported randomly. In testing, it is very rare that the error appears and when it does, running the report again typically works.
I am using the Action Javascript "Open a Report, Label or Letter Layout".
I have over 40 reports and only 3 produce the error randomly.
I have rebuilt the reports and changed them from Layout to Free-Form with no change
The Xbasic Error log on IIS shows 2 errors:
1) Script: a5w_SQL_TableFromResultSet() line 131create_table(tempfilename,tableStructure)=.f.: Too few parameters
2) The error that the report gave i.e. create_table
It appears that the a5w_SQL_TableFromResultSet is initiating the error.
Does anyone have any idea of what I can do here? Is this a SQL communication error?
I believe that this error started when I switched my database from mySql to mariaDB but I can't be sure.
Rob
I am on build 4866 using IIS and I have 3 reports that randomly trigger the following error:
Report did not print. Error reported was:
Layout name: C:\inetpub\Default Web Site\ContractPrint.a5rpt Layout type: report
create_table(tempfilename,tableStructure)=.f.: Too few parameters at line: 552
I have not been able to identify the pattern of the error as it is reported randomly. In testing, it is very rare that the error appears and when it does, running the report again typically works.
I am using the Action Javascript "Open a Report, Label or Letter Layout".
I have over 40 reports and only 3 produce the error randomly.
I have rebuilt the reports and changed them from Layout to Free-Form with no change
The Xbasic Error log on IIS shows 2 errors:
1) Script: a5w_SQL_TableFromResultSet() line 131create_table(tempfilename,tableStructure)=.f.: Too few parameters
2) The error that the report gave i.e. create_table
It appears that the a5w_SQL_TableFromResultSet is initiating the error.
Does anyone have any idea of what I can do here? Is this a SQL communication error?
I believe that this error started when I switched my database from mySql to mariaDB but I can't be sure.
Rob
Comment