Forum Discussion

JT26's avatar
JT26
New Contributor
2 years ago

SQL Error when using DM step type "Copy Data" to move archive data between Scenarios

Hi, I've been using a data management step (part of an archival sequence) to copy data between Scenarios and archive data. It has worked well in the past but now I'm getting below error when I run t...
Application Properties
Methodology
Planning
DanielWillis's avatar
DanielWillis
Valued Contributor

Think the first question is, is your process running any SQL queries?

It is a bit hard to diagnose something like this without more information. If it isn't your SQL then it sounds like its gonna be tricky. If if you are running SQL queries then narrow it down and feel free to share the SQL.

When you define a column numeric or decimal in an SQL Server database you specify the scale and precision (doc). If you try to store a number that doesn't fit in these bounds then it generates this error, e.g. decimal(8,2) has a max value of 999999.99

JT26's avatar
JT26
New Contributor
2 years ago

Thanks Daniel, my sequence isn't running any SQL. Its just the error number that gives a message hinting it maybe an issue with SQL in backend tables. I'm simply using the standard "Copy Data" functionality in OS Data Management using member filters below. It seems to be working for periods prior to M7 as well...