Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics RMS (Archived)

error #-2147217865

(0) ShareShare
ReportReport
Posted on by

Hidy ho all,

I'm in the process of prepping a demo register , and I have a singular problem.  We have an addon (which we didn't make, but try to support) for some of our clients.  This addon is perfectly functional with their database, but when I tried to apply it to a different stores database I started getting the above error.

The exact error is:

Error #-2147217865

Invalid object name 'tblUKI'

(Source Microsoft OLE DB Provider for SQL Server)

(NativeError: 208)

No Help file available

INSERT INTO tblUKI (Start) Values (1) SELECT SCOPE_INDENTIFY()

Now, if I'm reading this right, I need to add some values to the tblUKI table.  First, am I reading this right?

Second, if so, can I copy the values from another databse we have here , and just paste them into this database?

error #-2147217865
Invalid object name 'tblUKI'
(source microsoft OLE DB Provider for SQL Server)
(NativeError: 208)
No Help file available
INSERT INTO tblUKI (Start) Values (1) SELECT SCOPE_IDENTIFY()
Hidy ho all,
I'm trying to configure an sql database, to allow some custom made ad-ins for Dynamics RMS to function properly.
The error message i'm getting, when I try to run said add in, is:
error #-2147217865
Invalid object name 'tblUKI'
(source microsoft OLE DB Provider for SQL Server)
(NativeError: 208)
No Help file available
INSERT INTO tblUKI (Start) Values (1) SELECT SCOPE_IDENTIFY()
Now this tells me I have to add some values to the tblUKI table.
My question is, can I copy these values
Hidy ho all,
I'm trying to configure an sql database, to allow some custom made ad-ins for Dynamics RMS to function properly.
The error message i'm getting, when I try to run said add in, is:
error #-2147217865
Invalid object name 'tblUKI'
(source microsoft OLE DB Provider for SQL Server)
(NativeError: 208)
No Help file available
INSERT INTO tblUKI (Start) Values (1) SELECT SCOPE_IDENTIFY()
Now this tells me I have to add some values to the tblUKI table.
My question is, can I copy these values
Hidy ho all,
I'm trying to configure an sql database, to allow some custom made ad-ins for Dynamics RMS to function properly.
The error message i'm getting, when I try to run said add in, is:
error #-2147217865
Invalid object name 'tblUKI'
(source microsoft OLE DB Provider for SQL Server)
(NativeError: 208)
No Help file available
INSERT INTO tblUKI (Start) Values (1) SELECT SCOPE_IDENTIFY()
Now this tells me I have to add some values to the tblUKI table.
My question is, can I copy these values
Hidy ho all,
I'm trying to configure an sql database, to allow some custom made ad-ins for Dynamics RMS to function properly.
The error message i'm getting, when I try to run said add in, is:
error #-2147217865
Invalid object name 'tblUKI'
(source microsoft OLE DB Provider for SQL Server)
(NativeError: 208)
No Help file available
INSERT INTO tblUKI (Start) Values (1) SELECT SCOPE_IDENTIFY()
Now this tells me I have to add some values to the tblUKI table.
My question is, can I copy these values

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    on at
    RE: error #-2147217865

    Got it!

    I studied the functional database's tblUKI table, then had to re-create the table in the database having the problem.

    But its up and running now!

  • Community Member Profile Picture
    on at
    RE: error #-2147217865

    So, I'm still working on this problem.  I took another backup of a clients database, made a separate backup of it, and shrank it down to where I could move it on my flashdrive.

    Once I restored the database on my demo register, I was able to use the customization without any problems.

    Please note, I'm not asking for help trouble shooting that customization.  I am well aware that this forum does not help with customization's in any way.

    I'm asking if its possible to copy one table, from one database t another, without causing any complications to either.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,157 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,930 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans