Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

error 245 when running INSERT INTO @PJAIC_summary

Posted on by Microsoft Employee

I am running the Indirect rate calculator.

the process runs through al the data but at the end a stored procedure is faling:

INSERT INTO @PJAIC_summary

I get a System Error 245, the error in the SLQ trace is as follows:

Conversion failed when converting the varchar value 'G&A APPLIED     ' to data type int.

The statement started is

INSERT INTO @PJAIC_summary
    EXEC PJAIC_Summary @cpnyid, @period, 'Y', @project, @pjt_entity

how do I determine what is not set up correctly?

*This post is locked for comments

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans