R01 2017 to 2018

Home Forums Data issues R01 2017 to 2018

This topic contains 59 replies, has 15 voices, and was last updated by  sophie 2 years, 10 months ago.

Viewing 25 posts - 26 through 50 (of 60 total)
  • Author
    Posts

  • jamesfrancis
    Participant

    The message from the underlying logs is:

    Invalid object name ‘FIS_DATA_LARS_109_210817_151925.Version_005.LARS_FrameworkCmnComp’

    I’ve checked in the database and LARS_FrameworkCmnComp isn’t there for V5, but was for V4 and before. Import doesn’t seem to work if you try to roll the LARS back either.

    Do we need to fix the LARS DB somehow?

     
    #190666

    sampage
    Participant

    mine is just whirring (technical term!!)

     
    #190671

    Richard Phipps
    Participant

    Can I go home now?

     
    #190673

    sampage
    Participant

    I was thinking pub?!?!?!?!?!?!?

     
    #190677

    jamesfrancis
    Participant

    I’ll meet you there Sam!

     
    #190679

    Matt Collishaw
    Participant

    I take it that the ne version just released is not same? don’t really want to waste more time reinstalling the whole software again πŸ™‚

     
    #190681

    sampage
    Participant

    Your on James Francis – I’m Dorset – where is in the middle? We can drown our sorrow in alcohol and chips!!!

     
    #190685

    Richard Phipps
    Participant

    I’m in Loughborough!

     
    #190689

    jamesfrancis
    Participant

    I think they’ve omitted a SQL view from the update: Version_005.LARS_FrameworkCmnComp. I’ve recreated it manually using the same SQL as Version 4 and the ILR files seem to validate OK now.

    Should we expect a new LARS from ESFA?

    And Sam as I’m in Norwich I would suggest London, but I can’t afford the chips and they don’t do gravy there!

     
    #190699

    Richard Phipps
    Participant

    No gravy in London?

    James: If it’s not fixed tomorrow can you send me the SQL? πŸ™‚

     
    #190708

    MAmstell
    Participant

    Hi all,

    HUN have just notified that FIS 17/18 is now available.

    I am going to try and update and run the ILR through now.

    Thanks,
    Melissa

     
    #190717

    Matt Collishaw
    Participant

    James – you could post the sql here and do the job for them at leas then we will have a working version tomorrow πŸ™‚ chips and cheese for me!

     
    #190719

    MAmstell
    Participant

    HUB not HUN*

     
    #190721

    SFA data
    Participant

    Hi,

    Thanks James, you’re right that there is an issue with LARS.

    We’re working on this at the minute and hope to have this fixed by 3.45pm today.

    Sorry for the further inconvenience this has caused.

    Kind regards
    Lynne

     
    #190724

    sampage
    Participant

    Perhaps just copious amounts of alcohol then! and crisps!!!

    As mine does not work either I am leaving the building and eating chocolate and buying a tent to wear into work tomorrow!

    LYNNE – HELP – it does not work

    Execution Error
    Code:0008(TsqlTask)

     
    #190728

    Martin West
    Participant

    You would think they would have tested it before release, beggar’s belief

     
    #190739

    SFA data
    Participant

    Hi,

    We’ve implemented the fix, you’ll need to check for updates in FIS and download the latest LARS file.

    Kind regards
    Lynne

     
    #190741

    jamesfrancis
    Participant

    Thanks Lynne, after a couple of quick tests that appears to have fixed it.

    James

     
    #190743

    sampage
    Participant

    Hi Lynne

    Mine is NOT working no new LARS available – only Version 5.0.0 – 21 Aug

     
    #190747

    sampage
    Participant

    Hello just been advised ESFA have released the LARS with the same version number and date (V5 – 21 August) however if you look a the long version number it is different (10:52:28:807)

     
    #190753

    Martin West
    Participant

    It now works except for not populating the export mdb with FM36 funding data and the Apps Indicative Earnings report includes some onerous records for standards and learners not included in the ILR file.

     
    #190756

    sampage
    Participant

    mmmm not convinced myself we are getting a lot of errors on our rule violation report:

    PlanLearnHours_01

    These learners were due to finish in July 2017 and due to the nature of life and the universe have not yet been taken off PICS not sure as they should be showing as errors over planned hours that they should not have in the new academic year?

    Going to ask Pellcomp and Service Desk as confused.com

     
    #190762

    Sue Bishop
    Participant

    Guess we’ll wait till 9.30 tomorrow morning for an update then……..

     
    #190769

    MAmstell
    Participant

    Hi all,

    Can someone please advise on the warning I am getting from the FIS 17/18 rule violation report.

    W PHF4K42FLW32 LearnDelFAMDateFrom_01 LearnDelFAMType=’ACT’,LearnDelFAMCode=’2′ The Date applies from or the Date applies to must be returned for this FAM type 1 ZPROG001 f351df4f3e7de04d881d0bf52909bf4a 36

    Thanks,
    Melissa

     
    #190771

    sampage
    Participant

    Melissa – check that the date you have the qualification on the ILR components aims page of PICS matches the dates you have put in the ACT box lower down on the same screen

    Also look at ILR Prog Aim and check that your ACT date there matches the start date of the apprenticeship

    Other than that I am stuck

     
    #190778
Viewing 25 posts - 26 through 50 (of 60 total)

You must be logged in to reply to this topic.