Got error when opening a SQL 2008 db

Question

Post reply

Got error when opening a SQL 2008 db

Rod at work

SSC-Dedicated

Points: 34008
More actions
December 16, 2016 at 10:45 am

#332826

I got the following error when opening a SQL 2008 database with SSMS 2012:
(I hope you can see this. Posting snap shots into these forums is difficult.)
First of all, I've been able to do this for quite some time. Now I get this error.
When I click the Yes button it let's me through so I can do the work I'm trying to do, but I'm wondering why I'm getting these errors?
Kindest Regards, Rod Connect with me on LinkedIn.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

kevaburg SSCoach Points: 18131 More actions · Answer 1

kevaburg

SSCoach

Points: 18131

December 21, 2016 at 6:35 am

#1919130

What does the error in the XML file say?

Rod at work SSC-Dedicated Points: 34008 More actions · Answer 2

That's another weird thing. There is no AppEnv under C:\Users\rod.falanga\AppData\Roaming\Microsoft

And I have Show Hidden selected. I don't get why the error message would refer to a log file in a folder that doesn't exist.

Kindest Regards, Rod Connect with me on LinkedIn.

kevaburg SSCoach Points: 18131 More actions · Answer 3

Rod at work (12/21/2016)
That's another weird thing. There is no AppEnv under C:\Users\rod.falanga\AppData\Roaming\Microsoft
And I have Show Hidden selected. I don't get why the error message would refer to a log file in a folder that doesn't exist.

Did you run the application with the /log Parameter as described in the error message? I can imagine the folder and file will be created as a result of that.

Rod at work SSC-Dedicated Points: 34008 More actions · Answer 4

kevaburg (12/21/2016)
Rod at work (12/21/2016)
That's another weird thing. There is no AppEnv under C:\Users\rod.falanga\AppData\Roaming\Microsoft
And I have Show Hidden selected. I don't get why the error message would refer to a log file in a folder that doesn't exist.
Did you run the application with the /log Parameter as described in the error message? I can imagine the folder and file will be created as a result of that.

No, I did not. I'm sorry I didn't see that before. I won't be back to work until then so I'll try it once I get back to work.

Kindest Regards, Rod Connect with me on LinkedIn.

Rod at work SSC-Dedicated Points: 34008 More actions · Answer 5

I'm sorry it's taken me so long to get back to trying what you suggested. I've finally gotten a chance. Where's what I've found.

Once I created the log file (actually named ActivityLog.xml) in the folder I opened it in Notepad++ and searched for the string "ERROR". I'll show a few of the XML records near the one record that had "error" in it:

<entry>

<record>1211</record>

<time>2017/01/11 16:54:16.058</time>

<type>Information</type>

<source>VisualStudio</source>

<description>Deleted volatile pkgdef Configuration cache</description>

</entry>

<entry>

<record>1212</record>

<time>2017/01/11 16:54:16.058</time>

<type>Information</type>

<source>VisualStudio</source>

<description>Released pkgdef cache usage tracker</description>

<hr>00000001 - S_FALSE</hr>

<errorinfo>Unspecified error

</errorinfo>

</entry>

<entry>

<record>1213</record>

<time>2017/01/11 16:54:16.058</time>

<type>Information</type>

<source>VisualStudio</source>

<description>PkgDef registry shutdown complete</description>

</entry>

This was literally at the end of the log file, just before the closing </activity> tag.

Does this help with trying to figure out what's causing this error?

Kindest Regards, Rod Connect with me on LinkedIn.