Software Crash With Custom Sql Statement Follow

Legacy Poster

I'm trying to use a custom SQL statement to join a number of SQL views together into a table within Bartender's database connection setup tool. I am able to browse the table within the database connection setup window. But, when I hit the OK button to close the window the software crashes. This is the error report:


Problem signature:

Problem Event Name: APPCRASH

Application Name: bartend.exe

Application Version:

Application Timestamp: 51d23b6a

Fault Module Name:    KERNELBASE.dll

Fault Module Version: 6.1.7601.17932

Fault Module Timestamp: 50327672

Exception Code: e06d7363

Exception Offset: 0000c41f

OS Version: 6.1.7601.

Locale ID: 1033

Additional Information 1: 0a9e

Additional Information 2: 0a9e372d3b4ad19135b953a78882e789

Additional Information 3: 0a9e

Additional Information 4: 0a9e372d3b4ad19135b953a78882e789


SQL Statement:


SELECT DISTINCT org_SKAN1.Models.Number, org_SKAN1.Descriptions.Description, org_SKAN1.Categories.Description, org_SKAN1.Items.BarCode, org_SKAN1.Models.IsDeleted
FROM org_SKAN1.Models
JOIN org_SKAN1.Descriptions
ON org_SKAN1.Models.DescriptionId=org_SKAN1.Descriptions.DescriptionId
JOIN org_SKAN1.Categories
ON org_SKAN1.Models.CategoryId=org_SKAN1.Categories.CategoryId
JOIN org_SKAN1.Items
ON org_SKAN1.Models.ModelId=org_SKAN1.Items.ModelId
WHERE org_SKAN1.Models.IsDeleted='1'
ORDER BY org_SKAN1.Models.Number;


Version Info:

OS: Windows 7 Enterprise [x64], SP1

Edition: Enterprise Automation Trial

Version: 10.1
Build: 2926



Ian Cummings
Comment actions Permalink

We've just published v10.1 SR1 to the web, and I think a bug like this is one of the items fixed.  I suggest you download, install, and try it out:

Legacy Poster
Comment actions Permalink



Thanks for the help. I downloaded and installed v10.1 SR1. The bug is now gone. 

Please sign in to leave a comment.