SQL Error

[KCMarch]

Posting on behalf of Peter Bruckner:

Metamorphosis looks like a great tool for comparing Revit models in a granular way. Problem I'm having (on two separate computer systems (using Revit 2017) ends up with the same dialog error message:

Error! System. Data.SQLite.SQLiteException (Ox80004005): SQL logic erroror missing database near syntax error at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSqI, SQLiteStatement previous, Ulnt32 timeoutMS, String& strRemain) at System Data. SQLite. SQLiteCommand. auiIdNextCommand0 at System. Data. SQLite. SQLiteDataReader. NextResuIt0 at System. Data. SQLite. SQLiteDataReader.. ctor(SQLiteCommand cmd, Commandaehavior behave) System. Data. SQLite.SQLiteCommand. ExecuteReader(Command8ehavior behavior) System. Data. SQLite.SQLiteCommand. ExecuteNonQueMCommand8ehavi or behavior) at Metam orphosis. SnapshotMaker. updateHeaderTabIe0 at Metamorphosis. SnapshotMaker. exportParameterData0 at Metamorphosis. SnapshotMaker.Export0 at Metamorphosis. Snapshot. Execute(ExternaICommandData commandData, String& message, ElementSet elements)

Am I missing a component or related program (like SQL?)

Any help you can offer would be very welcome!

[thazell]

Hi Peter. Are you running this on a detached model?

[mattmas]

That’s a good thought – it feels like there’s some kind of unusual character in the filename, or something else odd (detached models have no path).

-Matt

From: thazell notifications@github.com Sent: Thursday, May 3, 2018 10:14 AM To: mattmas/Metamorphosis Metamorphosis@noreply.github.com Cc: Subscribed subscribed@noreply.github.com Subject: Re: [mattmas/Metamorphosis] SQL Error (#26)

CAUTION: Outside Sender

Hi Peter. Are you running this on a detached model?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://github.com/mattmas/Metamorphosis/issues/26#issuecomment-386310022, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AFexogpuD5oNtww2eN5fPE-K_hkz4Li7ks5tuxCzgaJpZM4TxHCS.

[pj-pilot]

This is a shared (central) file. Should I detach it first?

[mattmas]

No – if it’s a central file, then it’s not the issue Timon is suggesting. Don’t detach it.

Is there any chance you could share the model with me?

Thanks, Matt

Matt Mason IMAGINiT Technologies Brookline, MA T: +1 508-663-1462 Email: mmason@rand.commailto:mmason@rand.com imaginit.comhttp://www.imaginit.com/

From: pj-pilot notifications@github.com Sent: Thursday, May 3, 2018 1:36 PM To: mattmas/Metamorphosis Metamorphosis@noreply.github.com Cc: Matt Mason MMason@rand.com; Comment comment@noreply.github.com Subject: Re: [mattmas/Metamorphosis] SQL Error (#26)

CAUTION: Outside Sender

This is a shared (central) file. Should I detach it first?

— You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/mattmas/Metamorphosis/issues/26#issuecomment-386375783, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AFexoufEwCJKerE_kUtRwAo0K3EgD5h3ks5tuz_vgaJpZM4TxHCS.

[pj-pilot]

I'll be glad to share the model, although it must be kept confidential. Here's al link to the architectural file:� � https://www.dropbox.com/sh/ylgv9i95b0666zp/AAA11D0SB4XDPM9KgJIxPtx2a?dl=0 Regards, Peter I'll put it up on DropBox for you

---------------------------- Original Message ----------------------------

Subject: Re: [mattmas/Metamorphosis] SQL Error (#26)

From: "Matt Mason" notifications@github.com

Date: Thu, May 3, 2018 2:28 pm

To: "mattmas/Metamorphosis" Metamorphosis@noreply.github.com

Cc: "pj-pilot" peterb@pjbruckner.com

"Comment" comment@noreply.github.com

---

No – if it’s a central file, then it’s not the issue Timon is suggesting.

Don’t detach it.

Is there any chance you could share the model with me?

Thanks,

Matt

Matt Mason

IMAGINiT Technologies

Brookline, MA

T: +1 508-663-1462

Email: mmason@rand.commailto:mmason@rand.com

imaginit.comhttp://www.imaginit.com/

From: pj-pilot notifications@github.com

Sent: Thursday, May 3, 2018 1:36 PM

To: mattmas/Metamorphosis Metamorphosis@noreply.github.com

Cc: Matt Mason MMason@rand.com; Comment comment@noreply.github.com

Subject: Re: [mattmas/Metamorphosis] SQL Error (#26)

CAUTION: Outside Sender

This is a shared (central) file. Should I detach it first?

—

You are receiving this because you commented.

Reply to this email directly, view it on GitHubhttps://github.com/mattmas/Metamorphosis/issues/26#issuecomment-386375783, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AFexoufEwCJKerE_kUtRwAo0K3EgD5h3ks5tuz_vgaJpZM4TxHCS.

--

You are receiving this because you commented.

Reply to this email directly or view it on GitHub:

https://github.com/mattmas/Metamorphosis/issues/26#issuecomment-386392430

[mattmas]

I have retrieved it – please remove from Dropbox

From: pj-pilot notifications@github.com Sent: Thursday, May 3, 2018 10:16 PM To: mattmas/Metamorphosis Metamorphosis@noreply.github.com Cc: Matt Mason MMason@rand.com; Comment comment@noreply.github.com Subject: Re: [mattmas/Metamorphosis] SQL Error (#26)

CAUTION: Outside Sender

I'll be glad to share the model, although it must be kept confidential. Here's al link to the architectural file:� � https://www.dropbox.com/sh/ylgv9i95b0666zp/AAA11D0SB4XDPM9KgJIxPtx2a?dl=0 Regards, Peter I'll put it up on DropBox for you

---------------------------- Original Message ----------------------------

Subject: Re: [mattmas/Metamorphosis] SQL Error (#26)

From: "Matt Mason" notifications@github.com<mailto:notifications@github.com>

Date: Thu, May 3, 2018 2:28 pm

To: "mattmas/Metamorphosis" Metamorphosis@noreply.github.com<mailto:Metamorphosis@noreply.github.com>

Cc: "pj-pilot" peterb@pjbruckner.com<mailto:peterb@pjbruckner.com>

"Comment" comment@noreply.github.com<mailto:comment@noreply.github.com>

---

No – if it’s a central file, then it’s not the issue Timon is suggesting.

Don’t detach it.

Is there any chance you could share the model with me?

Thanks,

Matt

Matt Mason

IMAGINiT Technologies

Brookline, MA

T: +1 508-663-1462

Email: mmason@rand.commailto:mmason@rand.com<mailto:mmason@rand.com%3cmailto:mmason@rand.com>

imaginit.comhttp://www.imaginit.com/

From: pj-pilot notifications@github.com<mailto:notifications@github.com>

Sent: Thursday, May 3, 2018 1:36 PM

To: mattmas/Metamorphosis Metamorphosis@noreply.github.com<mailto:Metamorphosis@noreply.github.com>

Cc: Matt Mason MMason@rand.com<mailto:MMason@rand.com>; Comment comment@noreply.github.com<mailto:comment@noreply.github.com>

Subject: Re: [mattmas/Metamorphosis] SQL Error (#26)

CAUTION: Outside Sender

This is a shared (central) file. Should I detach it first?

—

You are receiving this because you commented.

Reply to this email directly, view it on GitHubhttps://github.com/mattmas/Metamorphosis/issues/26#issuecomment-386375783, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AFexoufEwCJKerE_kUtRwAo0K3EgD5h3ks5tuz_vgaJpZM4TxHCS.

--

You are receiving this because you commented.

Reply to this email directly or view it on GitHub:

https://github.com/mattmas/Metamorphosis/issues/26#issuecomment-386392430

— You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/mattmas/Metamorphosis/issues/26#issuecomment-386489663, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AFexoqe03LtdM2DsLeIpw6KtXO37QM7mks5tu7nigaJpZM4TxHCS.

[mattmas]

Peter (et al), I've posted a new version of Metamorphosis - 1.2. It includes:

• Support for Revit 2019-2015
• A workaround for Peter's issue (Peter - keep an eye on a group called "DS Outlet" in your model, I am suspicious it is somehow corrupt).

[pj-pilot]

I downloaded the latest link (note the date on the msi is 1-31-2017. Still get the same error message. Still have a strong project need for metamorphosis' functionality.

[mattmas]

Peter, If you download from here, the date on the MSI file should be 5/5/2018? https://github.com/mattmas/Metamorphosis/blob/master/addin/MetamorphosisInstaller.zip

-Matt

From: pj-pilot notifications@github.com Sent: Tuesday, May 8, 2018 3:13 PM To: mattmas/Metamorphosis Metamorphosis@noreply.github.com Cc: Matt Mason MMason@rand.com; State change state_change@noreply.github.com Subject: Re: [mattmas/Metamorphosis] SQL Error (#26)

CAUTION: Outside Sender

I downloaded the latest link (note the date on the msi is 1-31-2017. Still get the same error message. Still have a strong project need for metamorphosis' functionality.

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHubhttps://github.com/mattmas/Metamorphosis/issues/26#issuecomment-387510995, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AFexoscqBTFvFyQ9zkO_Cvs-xCDmPfwjks5twe4ogaJpZM4TxHCS.

[pj-pilot]

Matt: Here is a screenshot from my visit to the link just minutes ago. (The Zip file is dated today, but the .msi is dated 1/31/2017.) Is it necessary to remove the plugin from Revit  first?   Regards, Peter

---------------------------- Original Message ----------------------------

Subject: Re: [mattmas/Metamorphosis] SQL Error (#26)

From: "Matt Mason" notifications@github.com

Date: Tue, May 8, 2018 4:07 pm

To: "mattmas/Metamorphosis" Metamorphosis@noreply.github.com

Cc: "pj-pilot" peterb@pjbruckner.com

"Comment" comment@noreply.github.com

---

Peter,

If you download from here, the date on the MSI file should be 5/5/2018?

https://github.com/mattmas/Metamorphosis/blob/master/addin/MetamorphosisInstaller.zip

-Matt

From: pj-pilot notifications@github.com

Sent: Tuesday, May 8, 2018 3:13 PM

To: mattmas/Metamorphosis Metamorphosis@noreply.github.com

Cc: Matt Mason MMason@rand.com; State change state_change@noreply.github.com

Subject: Re: [mattmas/Metamorphosis] SQL Error (#26)

CAUTION: Outside Sender

I downloaded the latest link (note the date on the msi is 1-31-2017.

Still get the same error message.

Still have a strong project need for metamorphosis' functionality.

—

You are receiving this because you modified the open/close state.

Reply to this email directly, view it on GitHubhttps://github.com/mattmas/Metamorphosis/issues/26#issuecomment-387510995, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AFexoscqBTFvFyQ9zkO_Cvs-xCDmPfwjks5twe4ogaJpZM4TxHCS.

--

You are receiving this because you commented.

Reply to this email directly or view it on GitHub:

https://github.com/mattmas/Metamorphosis/issues/26#issuecomment-387526183

[mattmas]

Peter - I don't see the screenshot, but give the installer a try.

You may need to uninstall/reinstall. After installing, on the Snapshot command the window should show "Metamorphosis 1.2.0.0" in the dialog titlebar.

[pj-pilot]

Thanks. I did a full uninstall. (Renaming the old files in the addins directory did not work, had to remove them entirely). Now the dialog box reads as 1.2.0.0. Regards, Peter

Sent from my iPad

On May 8, 2018, at 22:15, Matt Mason notifications@github.com wrote:

Peter - I don't see the screenshot, but give the installer a try.

You may need to uninstall/reinstall. After installing, on the Snapshot command the window should show "Metamorphosis 1.2.0.0" in the dialog titlebar.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

[mattmas]

And is the issue resolved?

From: pj-pilot notifications@github.com Sent: Wednesday, May 9, 2018 9:10 AM To: mattmas/Metamorphosis Metamorphosis@noreply.github.com Cc: Matt Mason MMason@rand.com; State change state_change@noreply.github.com Subject: Re: [mattmas/Metamorphosis] SQL Error (#26)

CAUTION: Outside Sender

Thanks. I did a full uninstall. (Renaming the old files in the addins directory did not work, had to remove them entirely). Now the dialog box reads as 1.2.0.0. Regards, Peter

Sent from my iPad

On May 8, 2018, at 22:15, Matt Mason notifications@github.com<mailto:notifications@github.com> wrote:

Peter - I don't see the screenshot, but give the installer a try.

You may need to uninstall/reinstall. After installing, on the Snapshot command the window should show "Metamorphosis 1.2.0.0" in the dialog titlebar.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHubhttps://github.com/mattmas/Metamorphosis/issues/26#issuecomment-387732905, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AFexonWDeSLISyLZHz7uYDfXb1Qi6BtWks5twuqngaJpZM4TxHCS.

[pj-pilot]

Matt: Sadly not.� I just tried to snapshot another file and got the same dialog message:

Might there be a missing SQL database program that is needed? Regards, Peter � ---------------------------- Original Message ---------------------------- Subject: Re: [mattmas/Metamorphosis] SQL Error (#26)

From: "Matt Mason" notifications@github.com

Date: Wed, May 9, 2018 9:10 am

To: "mattmas/Metamorphosis" Metamorphosis@noreply.github.com

Cc: "pj-pilot" peterb@pjbruckner.com

"Comment" comment@noreply.github.com

---

And is the issue resolved?

From: pj-pilot notifications@github.com

Sent: Wednesday, May 9, 2018 9:10 AM

To: mattmas/Metamorphosis Metamorphosis@noreply.github.com

Cc: Matt Mason MMason@rand.com; State change state_change@noreply.github.com

Subject: Re: [mattmas/Metamorphosis] SQL Error (#26)

CAUTION: Outside Sender

Thanks. I did a full uninstall. (Renaming the old files in the addins directory did not work, had to remove them entirely). Now the dialog box reads as 1.2.0.0.

Regards,

Peter

Sent from my iPad

On May 8, 2018, at 22:15, Matt Mason notifications@github.com<mailto:notifications@github.com> wrote:

Peter - I don't see the screenshot, but give the installer a try.

You may need to uninstall/reinstall.

After installing, on the Snapshot command the window should show "Metamorphosis 1.2.0.0" in the dialog titlebar.

—

You are receiving this because you commented.

Reply to this email directly, view it on GitHub, or mute the thread.

—

You are receiving this because you modified the open/close state.

Reply to this email directly, view it on GitHubhttps://github.com/mattmas/Metamorphosis/issues/26#issuecomment-387732905, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AFexonWDeSLISyLZHz7uYDfXb1Qi6BtWks5twuqngaJpZM4TxHCS.

--

You are receiving this because you commented.

Reply to this email directly or view it on GitHub:

https://github.com/mattmas/Metamorphosis/issues/26#issuecomment-387733143

[mattmas]

Drat. When I looked at it, I wasn't getting exactly the same issue as you, but I hoped it was resolved when it worked for me. Re-opening the issue.

[hamdibr]

Hello everyone, I still have the same error, i use Revit 2019. I try it even in a file with just 4 wall and nothing elese. Is it a problem of caractere, since i use french version of revit ?

[mattmas]

Yes, it is a problem that we’re not properly handling certain words that contain ‘ within them. I’m preparing an update for Revit 2021 in the next week or two, I’ll see if we can get that issue addressed as well.

-Matt

From: hamdibr notifications@github.com Sent: Wednesday, March 25, 2020 3:42 AM To: mattmas/Metamorphosis Metamorphosis@noreply.github.com Cc: Matt Mason mmason@rand.com; State change state_change@noreply.github.com Subject: Re: [mattmas/Metamorphosis] SQL Error (#26)

_ CAUTION - External Email

Hello everyone, I still have the same error, i use Revit 2019. I try it even in a file with just 4 wall and nothing elese. Is it a problem of caractere, since i use french version of revit ?

[image]https://user-images.githubusercontent.com/26900980/77512936-44567580-6e74-11ea-9937-a0d5e005d540.png

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHubhttps://github.com/mattmas/Metamorphosis/issues/26#issuecomment-603688822, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ABL3DIVJ2H23YFBELXIZI7DRJGYWFANCNFSM4E6EOCJA.

[hamdibr]

@mattmas thx