NAV2017 TaskScheduling not work

Comments

• Options

  mohana_cse06 Member Posts: 5,503

  2016-09-14

  Aren't you under NDA?
  Can you post these CTP issues?

  
  -Mohana
  http://mohana-dynamicsnav.blogspot.in/
  https://www.facebook.com/MohanaDynamicsNav

  0
• Options

  garak Member Posts: 3,263

  2016-09-14 edited 2016-09-14

  Yes i'm under NDA, also posted there, but no answer :-(
  
  so founf the solution self:
  
  System send:

  ---

  declare @id uniqueidentifier;
  declare @tenantId nvarchar(128);
  declare @notbefore datetime;
  declare @state int;
  declare @serverInstanceId int;
  declare @retries int;
  
  set @id='862546B2-3598-43B3-8BE2-E2DAF7C1B3EA';
  set @tenantId=N'default';
  set @notbefore='2016-09-13 22:00:00';
  set @state=1;
  set @serverInstanceId=0;
  set @retries=0;
  
  INSERT INTO [Demo Upgrade NAV (10-0)].[dbo].[$ndo$taskscheduling] ([id],[tenantid],[not_before],[state],[Server Instance ID],[retries])
  VALUES (@id,@tenantid,@notbefore,@state,@serverInstanceId,@retries)

  ---

  
  <--- variable @tenantid declared as @tenantId but used in Insert as @tenantid.
  
  Why it works on "Demo" instance from DVD --> Server Collaction.
  Our System that the admin gives us is --> SQL_Latin1_General_CP850_CS_AS :-/ :-/
  The default of on DVD is Latin1_General_CI_AS
  
  So, with the CP850 the variable not declared, with CI_AS it is
  
  Post can be closed.

  Do you make it right, it works too!

  0