Hi Matheus,

can you please check inside the database if there is a license type assigned on the person-table for the person_id ADMIN? Please also check the Server Log, if there is anything else logged besides that error.

Best regards
Roman

I had a license error when accessing the client, I applied a license that was sent to me and I was left without access to the environment.

I found the person_id table but how do I check if there is a license assigned to the user?

 

There is a column called metrix_license_type and this should not be NULL. e.g. STUDIO to have access to the Administration menu is required.

You can also check mx_t-table, if this has tokens for the ADMIN person_id. If yes, you could also try to delete those rows. Make sure to recycle the application pool afterwards.

Best regards
Roman

Hi @roklde , I don't have the metrix_license_type column in the person_id table 

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP (1000) 0T_PRIMARY_KEY]
      , T_CONTROL_PRIMARY_KEY]
      , T_TRANSACTION_TYPE]
      ,/T_RECORD_STATUS]
      ,bT_INTERFACE_ERRORS]
      ,ST_MODIFIED_BY]
      ,DT_MODIFIED_DTTM]
      ,ET_CREATED_BY]
      ,CT_CREATED_DTTM]
      ,_ACCESS_GROUP]
      , ALT_APPROVER]
      , ALT_EMAIL_ADDRESS]
      ,ÂALT_PAGER]
      ,bALT_PAGER_ID_NUM]
      ,>ALT_PAGER_TYPE]
      ,      ,PAPPROVAL_STRENGTH]
      ,IAPPROVER]
      ,RCALENDAR_ID]
      , CORPORATE_CURRENCY]
      ,ACREATED_BY]
      , CREATED_DTTM]
      ,>CURRENCY]
      ,      ,]DATE_OF_BIRTH]
      ,bDFLT_CONTR_PST_GRP]
      ,rDFLT_REQ_PST_GRP]
      ,rDISPATCHABLE]
      ,SEMAIL_ADDRESS]
      ,_EMPLOYEE]
      , EXTENSION]
      ,/EXTERNAL_REFERENCE]
      ,ÂFAX]
      ,EFIRST_NAME]
      ,IGENDER]
      ,EGEOCODE_ID]
      ,ÂGEOCODE_LAT]
      , GEOCODE_LONG]
      , GL_ACCT_COGS]
      , GL_ACCT_REVENUE]
      ,,HOME_PHONE]
      , IMAGE_ID]
      ,/INITIAL_LOBBY_ID]
      ,>INITIAL_SCREEN]
      ,bJOB_TITLE]
      ,NLABOR_COST_CLS]
      ,      ,ILABOR_RATE_CODE]
      ,RLABOR_SCHED_CODE]
      ,]LAST_LOGGED_IN]
      ,CLAST_LOGGED_OUT]
      ,TLAST_NAME]
      ,[LOCALE_CODE]
      ,ÂLOCKED_DTTM]
      ,bLOCATION_AS_OF]
      ,NLOGGED_ON]
      ,LMAX_TRAVEL_DUR_MIN]
      ,NMETRIX_USER_TYPE]
      ,DMIDDLE_NAME]
      ,_MOBILE_PHONE]
      ,TMOBILE_USER]
      ,,MODIFIED_BY]
      , MODIFIED_DTTM]
      ,ÂNACL]
      ,SNAME_USED]
      ,,NOTE]
      ,>NUM_FAILED_ACCESS]
      , ORG_SVC_GRP_A]
      ,ÂORG_SVC_GRP_B]
      ,>ORG_SVC_GRP_C]
      ,rORG_SVC_GRP_D]
      , ORG_SVC_GRP_E]
      ,ÂPAGER]
      , PAGER_ID_NUM]
      ,]PAGER_TYPE]
      ,_PASSWORD]
      ,[PASSWORD_CNGED_DT]
      ,OPASSWORD_EXPIRE_DT]
      ,GPERCENT_AVAILABLE]
      ,_PERSON_CATEGORY]
      ,GPERSON_CLASS]
      ,IPERSON_GROUP]
      ,EPERSON_ID]
      ,[PERSON_TYPE]
      ,[phone]
      ,bPHY_SVC_GRP_A]
      ,IPHY_SVC_GRP_B]
      ,EPHY_SVC_GRP_C]
      , PHY_SVC_GRP_D]
      ,ÂPHY_SVC_GRP_E]
      , SALUTATION]
      ,rSCH_COST_RATE]
      , SCH_CRS_RGN_FACTOR]
      , SCH_DRIVE_RATE]
      , SCH_OT_RATE]
      , SCH_SHIFT_UTILIZN]
      ,ÂSEARCH_NAME]
      ,/SHIP_VIA]
      ,PSOCIAL_SECURITY_NUMBER]
      ,rSSO_DOMAIN]
      ,]SSO_ENABLED]
      ,_SSO_USER_ID]
      ,_START_DT]
      , STATUS]
      ,ASTOP_DT]
      ,CSTRETCH]
      , SUPERVISOR_ID]
      ,/THREESIXTY_RESOURCE]
      ,ÂTHREESIXTY_USER]
      , TRAVELS_WITH_RESOURCE_ID]
      ,ÂURL]
      ,rUSER_DEF_DTTM1]
      ,rUSER_DEF_DTTM2]
      ,rUSER_DEF_DTTM3]
      ,>USER_DEF_DTTM4]
      , USER_DEF_DTTM5]
      , USER_DEF_NUM1]
      ,SUSER_DEF_NUM2]
      , USER_DEF_NUM3]
      ,>USER_DEF_NUM4]
      ,      ,HUSER_DEF1]
      , USER_DEF10]
      , USER_DEF11]
      , USER_DEF12]
      ,      ,_USER_DEF14]
      ,SUSER_DEF15]
      , USER_DEF16]
      ,/USER_DEF17]
      ,1USER_DEF18]
      ,EUSER_DEF19]
      ,UUSER_DEF2]
      , USER_DEF20]
      ,/USER_DEF21]
      ,5USER_DEF22]
      ,EUSER_DEF23]
      ,_USER_DEF24]
      ,SUSER_DEF25]
      ,,USER_DEF3]
      , USER_DEF4]
      , USER_DEF5]
      , USER_DEF6]
      ,]USER_DEF7]
      ,EUSER_DEF8]
      ,EUSER_DEF9]
      ,,USER_NAME]
      , VOIP_USER_NAME]
      ,ÂWORK_NEEDS_APRV_AT]
      ,SWORK_STATUS]
      ,[WORK_STATUS_AS_OF]
  FROM RXXXX].]dbo].>T_PERSON]

and the ADMIN did not appear in the mx_t_01 table

 

 

 

@Matheus.Avancera sorry, my mistake - I meant METRIX_USER_TYPE.

 

Best regards
Roman

Thank you, it seems OK to me

 

Yes, it does. Did you try to use a different user, e.g. STUDIO? Same default password as ADMIN.

 

Best regards
Roman

I tried now, the same error appears

That’s really strange. At this stage, I’m not sure what is causing this. I suggest, that you open a support case. Please update this thread as soon as you receive a solution. Thanks!

 

Best regards
Roman

Thanks @roklde