ERROR Permission denied. 'SUSER_SNAME' cannot be invoked with parameters in this version of SQL Server.

[hemmo241000]

Hi,

How to avoid following problem (bug or)?

Briefly:
I connected to azure sql server
"Microsoft SQL Azure (RTM) - 12.0.2000.8 Oct 2 2025 00:38:42 Copyright (C) 2025 Microsoft Corporation"

I used "import-file" and run command

c:\work\azure>java -Xmx6g -Djava.io.tmpdir=c:\tmp -jar "-Dfile.encoding=UTF-8" ......dbptk-app-4.3.0.jar migrate -i import-config --import-file azure.yaml -e siard-2 --export-file=azure.siard

I got error "ERROR Permission denied. 'SUSER_SNAME' cannot be invoked with parameters in this version of SQL Server."
and no siard file generation!

If I set following into import-file:
ignore:
users: true

It generates siard file but then I got validation problems e.g

M_5.1-1-17: [ERROR] : User node is mandatory (metadata.xml dbname:xxxx)
and
M_5.17-1: [ERROR] : Nothing found in this path /ns:siardArchive/ns:users/ns:user

Regards

Tuomo

[hemmo241000]

Hi,

It seems to be sql syntax problem!

I avoided problem by adding "user" xml element to metadata:

x.siard\header\metadata.xml

users:
<user
<name xxx</name
</user

I need to use following config in import-file to avoid error:
ignore:
users: true

In that case xml element
"user" is not filled!

I used 7zip to edit metadata.xml!

Regards

Tuomo

[dosubot]

Hi, @hemmo241000. I'm Dosu, and I'm helping the keeps/dbptk-developer team manage their backlog and I'm marking this issue as stale.

Issue Summary:

• You reported a "Permission denied" error related to 'SUSER_SNAME' on Azure SQL Server during migration, blocking SIARD file generation.
• You found a workaround by manually adding a "user" XML element and setting "ignore: users: true" in the import config.
• This workaround leads to validation errors due to missing user data.
• No maintainer responses or alternative solutions have been provided so far.

Next Steps:

• Please let us know if this issue is still relevant with the latest version of keeps/dbptk-developer by commenting here.
• If we do not hear back within 7 days, this issue will be automatically closed.

Thank you for your understanding and contribution!

[hemmo241000]

Hi,

Error is still there I tried with 4.4.0 version (see below)! I doubt sql syntax...

Regards

Tuomo

---

2026-05-04 16:09:54,035 [main] DEBUG (c.d.Main) # START v4.4.0
:
2026-05-04 16:09:56,043 [main] ERROR (c.d.Main) Permission denied. An error occurred during the current command (Done status 0). 'SUSER_SNAME' cannot be invoked with parameters in this version of SQL Server.
com.databasepreservation.model.exception.PermissionDeniedException: Permission denied. An error occurred during the current command (Done status 0). 'SUSER_SNAME' cannot be invoked with parameters in this version of SQL Server.
at com.databasepreservation.modules.sqlserver.SQLServerExceptionNormalizer.normalizeException(SQLServerExceptionNormalizer.java:41)
at com.databasepreservation.modules.sqlserver.in.SQLServerJDBCImportModule.normalizeException(SQLServerJDBCImportModule.java:315)
at com.databasepreservation.modules.jdbc.in.JDBCImportModule.getDatabaseStructure(JDBCImportModule.java:429)
at com.databasepreservation.modules.jdbc.in.JDBCImportModule.migrateDatabaseTo(JDBCImportModule.java:2100)
at com.databasepreservation.DatabaseMigration.migrate(DatabaseMigration.java:123)
at com.databasepreservation.Main.runMigration(Main.java:295)
at com.databasepreservation.Main.internalMain(Main.java:125)
at com.databasepreservation.Main.main(Main.java:81)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An error occurred during the current command (Done status 0). 'SUSER_SNAME' cannot be invoked with parameters in this version of SQL Server.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer$FetchBufferTokenHandler.onDone(SQLServerResultSet.java:5403)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:99)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:37)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:5493)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1801)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1059)
at com.databasepreservation.modules.jdbc.in.JDBCImportModule.getUsers(JDBCImportModule.java:1015)
at com.databasepreservation.modules.jdbc.in.JDBCImportModule.getDatabaseStructure(JDBCImportModule.java:416)
... 5 common frames omitted
2026-05-04 16:09:56,045 [main] INFO (c.d.m.r.Reporter) A report was generated with a listing of information that was modified during the conversion.
2026-05-04 16:09:56,045 [main] INFO (c.d.m.r.Reporter) The report file is located at C:\work\ura\ka_1225_tyokalut\dbptk-report-20260504160954048.txt
2026-05-04 16:09:56,046 [main] INFO (c.d.Main) Log files and migration reports were saved in C:\work\ura\ka_1225_tyokalut
2026-05-04 16:09:56,046 [main] INFO (c.d.Main) Troubleshooting information can be found at https://github.com/keeps/dbptk-developer/wiki/Troubleshooting
2026-05-04 16:09:56,046 [main] INFO (c.d.Main) Please report any problems at https://github.com/keeps/dbptk-developer/issues/new
2026-05-04 16:09:56,046 [main] DEBUG (c.d.Main) #########################################################
2026-05-04 16:09:56,046 [main] DEBUG (c.d.Main) # FINISH-ID-1b7a8a66-d918-4899-9db4-a4eaf0750def
2026-05-04 16:09:56,046 [main] DEBUG (c.d.Main) # FINISH v4.4.0
2026-05-04 16:09:56,046 [main] DEBUG (c.d.Main) # EXIT CODE: 1
2026-05-04 16:09:56,046 [main] DEBUG (c.d.Main) #########################################################