Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS (Archived)

error #-2147217865

Posted on by Microsoft Employee

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
    Community Member Microsoft Employee 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
    Community Member Microsoft Employee 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

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans