Error loading file in command line only

30 views
Skip to first unread message

ASing

unread,
Apr 14, 2024, 2:56:25 PMApr 14
to Arelle-users
Hello, 

I am getting the following error when loading a file via the command line but it loads find via the UI. 

[ProgrammingError] [Exception] Failed to complete request:

{FIRST DATA LINE OF XBRL FILE}

['  File "D:\\a\\Arelle\\Arelle\\arelle\\CntlrCmdLine.py", line 1101, in run\n', '  File "C:\\Program Files\\Arelle\\plugin\\xbrlDB\\__init__.py", line 213, in xbrlDBCommandLineXbrlRun\n    storeIntoDB(dbConnection, modelXbrl, entrypoint=entrypoint)\n', '  File "C:\\Program Files\\Arelle\\plugin\\xbrlDB\\__init__.py", line 170, in storeIntoDB\n    result = insertIntoDB(modelXbrl, host=host, port=port, user=user, password=password, database=db, timeout=timeout, product=product, rssItem=rssItem, **kwargs)\n             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n', '  File "C:\\Program Files\\Arelle\\plugin\\xbrlDB\\XbrlSemanticSqlDB.py", line 68, in insertIntoDB\n    xbrlDbConn.insertXbrl(entrypoint, rssItem)\n', '  File "C:\\Program Files\\Arelle\\plugin\\xbrlDB\\XbrlSemanticSqlDB.py", line 164, in insertXbrl\n    self.insertDataPoints()\n', '  File "C:\\Program Files\\Arelle\\plugin\\xbrlDB\\XbrlSemanticSqlDB.py", line 1081, in insertDataPoints\n    insertFactSet(self.modelXbrl.facts, None)\n', '  File "C:\\Program Files\\Arelle\\plugin\\xbrlDB\\XbrlSemanticSqlDB.py", line 1058, in insertFactSet\n    table = self.getTable(\'data_point\', \'datapoint_id\',\n            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n', '  File "C:\\Program Files\\Arelle\\plugin\\xbrlDB\\SqlDb.py", line 906, in getTable\n    result = self.execute(sqlStmt,commit=commit, close=False, fetch=fetch, params=params)\n             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n', '  File "C:\\Program Files\\Arelle\\plugin\\xbrlDB\\SqlDb.py", line 340, in execute\n    cursor.execute(sql)\n', '  File "C:\\hostedtoolcache\\windows\\Python\\3.11.9\\x64\\Lib\\site-packages\\pg8000\\legacy.py", line 281, in execute\n'] - filename


Any help would be appreciated. 


Thank you,

Anne

Austin Matherne

unread,
Apr 17, 2024, 1:43:45 PMApr 17
to Arelle-users
Hi,

If you can provide the command you're running I can take a look.

Kind regards,
Austin Matherne

Reply all
Reply to author
Forward
0 new messages