Share via

Getting error while creating source data format in data management in UAT environment.

Anonymous
2023-12-19T12:28:58+00:00

I am facing an error while opening the configure data source tile in data management in UAT(Sandbox) environment.

If I tried to create a new record i am facing following error.

session 3939 (praveetha)

INSERT INTO DMFSTAGINGERRORCODE (DESCRIPTION,ERRORCODE,LABELID,RECVERSION,PARTITION,RECID) VALUES (?,?,?,?,?,?)

[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]String or binary data would be truncated in table 'db_d365opsprod_aspuat_ax_20231018_02040218_a62d.dbo.DMFSTAGINGERRORCODE', column 'LABELID'. Truncated value: '@DMF:ColumnDel'.

Object Server Azure:

Cannot create a record in Staging error (DMFStagingErrorCode).

Error code: DMF1999, Column delimiter not found error. The SQL database has issued an error.

Cannot edit a record in Source data formats (DMFDataSource). The record has never been selected.

Can anyone help me to sort out?

Microsoft 365 and Office | Project | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2023-12-20T04:20:37+00:00

Hi Dale,

 Thanks for the information. Instead of D 365, I posted the question in Microsoft 365 by mistake. Will post correctly.Thanks!

Was this answer helpful?

0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Dale Howard [MVP] 29,860 Reputation points MVP Volunteer Moderator
    2023-12-20T19:46:46+00:00

    Excellent. Well done, my friend!

    Was this answer helpful?

    0 comments No comments
  2. Dale Howard [MVP] 29,860 Reputation points MVP Volunteer Moderator
    2023-12-19T15:08:01+00:00

    Shanmugapriya --

    You have erroneously posted your question in a user forum that is dedicated to Microsoft Project management tools, such as Microsoft Project and Project Online. I cannot determine precisely which application you are using, but it does not look like any of Microsoft's project management tools. Therefore, I would recommend that you submit your question in a user forum dedicated to the application you are using. Hope this helps.

    Was this answer helpful?

    0 comments No comments