hexagon logo

Datapage error

Relatively inexperienced with datapage. Using datapage 2011 and 4.1. On two of my cmms (using 2011 on one and 4.1 on the other), I am getting the following error "String or binary data would be truncated. The statement has been terminated". The data is not being sent to datapage. I tried rewriting the external comand in my program and this help for a short time and the error returned. Any ideas????
  • The error sounds like it is begin reported from DataPageStats.exe and likely it received this from the SQL Server (depends on when the error appears).

    When you use DataPageStats.exe it will create a text file containing all your program data. Turn off the DataImporter and run a program then have a look at the file (you can use notepad). I would look for anything that seems out of place (too big, something out of place).

    If the problem only happens when the DataImporter tries to send it to the database then I would start by creating a new database and see if the problem disappears. If so, then you might have something wrong with your database.