We are Cloud based Kinetic and need to be able to obtain a list of which Menu Security ID’s Security Groups assigned to? Can this be done through a BAQ? If so, what table do I need to include and what join will apply?
Security Group | Menu Security ID | Menu Name
If you look at the tables, Security and Menu, it should give you a good start. You should be able to identify what Security groups are tied to a specific Security ID and Menu those IDs have access.
there is a “menu security audit report” you can try. id apply some of the filters as the full log is alot of data to dig through…
I tried to run the audit report and it errors out with no records available regardless of filtering to a single menu and/or a single security group.
Maybe you don’t have security privileges to run the security report?
What is the error (task log) details in the System Monitor with those failed reports?
I am a System Manager. There is no error related to my security access.
The log is as follows…
Program Ice.Services.Lib.RunTask when executing task 951217 raised an unexpected exception with the following message: RunTask: System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column ‘UserName’, table ‘@userAccess’; column does not allow nulls. INSERT fails. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at Ice.Core.RptBase.BaqDataWriter.WriteTable(QueryRef queryRef, IDataReader dataReader) in F:\_Releases\11.3.100\UD11.3.100.8\Source\Server\Internal\Lib\TaskLib\RptBase\BaqDataWriter.cs:line 62 at Ice.Core.RptBase.BaqDataWriter.WriteTables(HierarchicalQueryResult queryResults) in F:\_Releases\11.3.100\UD11.3.100.8\Source\Server\Internal\Lib\TaskLib\RptBase\BaqDataWriter.cs:line 52 at Ice.Core.RptBase.BaqDataWriter.WriteTables() in F:\_Releases\11.3.100\UD11.3.100.8\Source\Server\Internal\Lib\TaskLib\RptBase\BaqDataWriter.cs:line 44 at Ice.Core.RptBase.ReportDataBuilderBase.WriteBaqTables() in F:\_Releases\11.3.100\UD11.3.100.8\Source\Server\Internal\Lib\TaskLib\RptBase\ReportDataBuilderBase.cs:line 317 at Ice.Core.RptBase.ReportDataBuilderBase.XMLClose() in F:\_Releases\11.3.100\UD11.3.100.8\Source\Server\Internal\Lib\TaskLib\RptBase\ReportDataBuilderBase.cs:line 213 at Ice.Core.RptBase.ReportDatabaseBuilder.XMLClose() in F:\_Releases\11.3.100\UD11.3.100.8\Source\Server\Internal\Lib\TaskLib\RptBase\ReportDatabaseBuilder.cs:line 94 at Ice.Core.RptTaskBase1.XMLClose() in F:_Releases\11.3.100\UD11.3.100.8\Source\Server\Internal\Lib\TaskLib\RptBase\RptTaskBase.cs:line 230 at Ice.Core.RptTaskBase1.RunDynamicCriteriaReport(IEnumerable1 criteriaParameters, IEnumerable1 criteriaMappings) in F:\_Releases\11.3.100\UD11.3.100.8\Source\Server\Internal\Lib\TaskLib\RptBase\RptTaskBase.cs:line 166 at Ice.Lib.DynamicCriteria.DynamicCriteriaReport.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:\_releases\ICE\ICE4.3.100.0\Source\Server\Internal\Lib\DynamicCriteria\DynamicCriteriaReport.cs:line 44 at Ice.Core.TaskBase1.StartProcess(Int64 instanceTaskNum, String outputFileName) in F:_Releases\11.3.100\UD11.3.100.8\Source\Server\Internal\Lib\TaskLib\TaskBase\TaskBase.cs:line 83 at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:_releases\ICE\ICE4.3.100.8\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 113 at Ice.Hosting.TaskCaller.ExecuteTask() in C:_releases\ICE\ICE4.3.100.8\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 61 at Ice.Hosting.TaskCaller.ExecuteTask(IceDataContext dataContext, Boolean suppressTransaction) in C:_releases\ICE\ICE4.3.100.8\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 41 at Ice.Services.Lib.RunTaskSvc.<>c__DisplayClass30_2.b__1() in C:_releases\ICE\ICE4.3.100.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 460 at Ice.Lib.RunTask.BpmFriendlyTaskLauncher.Run(String sessionIdPrefix, IceContext db, Action taskRunner) in C:_releases\ICE\ICE4.3.100.0\Source\Server\Services\Lib\RunTask\BpmFriendlyTaskLauncher.cs:line 57 at Ice.Services.Lib.RunTaskSvc.InnerRunTask(Int64 ipTaskNum, Boolean suppressTransaction) in C:_releases\ICE\ICE4.3.100.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 457 ClientConnectionId:987b601a-01b3-4e0a-b98d-6d81b5f19e88 Error Number:515,State:2,Class:16
No worries… sorry, just a bad joke.
Looks like some kind of parameter failure… 
You’re not trying to update the database directly, are you?
Have a look at Ice.Security table.
Cols: EntryList, NoEntryList
Not updating. Only trying to run the report.
I know I’m waaay late to the party, but was there any resolution on this one? I was running this report yesterday in prod as a Security Manager, and today it’s throwing the null username error.
I’m getting this same error: Cannot insert the value NULL into column ‘UserName’
Did anyone find a resolution?
Unfortunately yes/no - per support "This issue is related to Problem PRB0282454/ Development ticket ERPS-254846 and will be addressed in Kinetic 2024.2, when your Pilot site is upgraded in November 2024 and Production in December 2024. "
So, no relief anytime soon. I did ask for suggestions as to a workaround, or a BAQ that can get me close (it’s a nightmare without the report sorting field in the RDD BAQ which I can’t modify). Will share if I get anything.
Feedback from support - there is a datafix available for this issue.
I ran it, came up with two records that were causing problems (what happened that caused those two to be problems and why there were only two records idk), but the report is working now. Fingers crossed that no new problems pop up.
