XbrlDB semanticDB errors on store to DB

35 views
Skip to first unread message

Sherif ElGamal

unread,
Mar 9, 2020, 6:17:15 PM3/9/20
to Arelle-users
Hi,

I had some errors when using XbrlDB plugin store to semanticDBs, mostly on first time creation of the database, suggested fixes here and patch files attached.

Errors descriptions as follows:
mmsql: "Can't find procedure GO" --> GO is only recognized by ssms
orcl:  cannot establish connection with db --> db variable not included in connection string
mysql: fails on insert with "Field 'report_id' doesn't have a default value" --> triggers/sequences do not get created, also pymysql does not recognize 'DELIMITER'
jsonFile: error "Type not supported" when fact.xmlLang is missing and disclosureSystem validation is not enabled when on ModelValue objects.

Also included some updates for industry classifications tables.






 

patches.rar
Reply all
Reply to author
Forward
0 new messages