HiUnless the company hosting your Cloud installation allows a direct connection to your database (which is very unlikely) I think there are a couple of options:implement quick reports or other queries within IFS to download the data use the REST APIs built into IFS Cloud to download the data. I believe the OAuth2 authentication required to connect to the REST APIs means that you’ll probably need to handle the downloads in VBA if you decide to do this within Excel or Access.Hope this helps, although I guess either route is a significant change from your current approach.
Hi,Do you have access to the Office365 administration? I think you’ll have to disable multi-factor authentication for the email account being used when using basic authentication.Best regards,Marion
Hi @hamalk Many thanks for your response, but the problem was just an attribute so the suggestion in the other article didn’t apply.In case it helps anyone else, I have found a solution which is just to ensure than the attribute name includes the word ‘Description’. This seems to ensure that the serialization is done differently and handles the special characters.Thanks again,Marion
Hi LindaWe’re also in 22.2 and we get ‘invalid format’ as well if two dates are typed in rather than selected from the calendar widget.It happens even if you copy and paste the range as supplied by the calendar widget.Regards,Marion
I’ve just found which says I should use AL32UTF8, and this has worked.
Hi,Just as a belated comment in case it helps anyone, we have just seen the same behaviour on 22.2.1.Best regards,Marion
Hi GonzaloWe also kicked off another delivery and this time it’s worked, even though there have been no changes.So, no explanation, but at least we can progress with the delivery!Thank you for taking the time to respond.Best regards,Marion
Hi GonzaloWe did another DEV build after the sanity build (we requested it this morning, and the sanity build was done yesterday). It’s running OK. We did notice that it didn’t take very long to build though, it was much quicker than the original DEV build. Would you expect that?Thanks,Marion
Hi GonzaloI think perhaps I have misunderstood.“It would be a good check to verify that a new environment can be spawned using the latest commit tagged with a successful sanity tag”We’re not able to select a sanity tag when we do a DEV build, only the master branch.Thanks,Marion
Hi GonzaloMany thanks for your response.Yes, I did a DEV build and that environment ran ok but that was before the sanity build. Are you suggesting doing another DEV build with the sanity tag as the basis? I’ll give that a go now…Thanks again,Marion
In case it helps anyone else, I found the source of the problem.The outbound rule must include some content based conditions, which I was missing:
HiCheck the permission set for your user as the projection may now be showing with an access level of ‘custom’. It should be ‘full’.You may also need to refresh the security cache.Hope this helps!
HiWe’ve typically used an ‘all projections’ type permission set for users working on data migrations as they need permission for any projections for the data being migrated as well as the actual data migration management projections.The latter can be found by filtering the projections for the FNDMIG component.The ‘authorised users’ in the data migration basic data needs to be set for anyone to see a migration job created by someone else.Hope this helps.
HiThe only other thing I can think of is to check that the revision phase in dates are set consistently.
HiI know you’ve said you’ve checked the part on both sites, but it sounds like the part revision definition on one site includes an engineering revision but not on the other site?If you are using engineering revisions then this will need to be created on the other site, if not then I guess remove it from the part revision definition on the first site?Hope this helps
Hi PriyankaCan you provide the details of the actual migration job?
HiIn that case the query is slightly easier, you should be able to useselect activity_seq, amount, unit, sys_code, code, NULL as AMT from GL_Ledger_Xunionselect activity_seq, NULL as amount, NULL as unit, NULL as sys_code, NULL as code AMT from Budget_Y You just need to align the columns for the union.Hope this helps.
HiYou can achieve this with a union but you’ll need to define each of the columns that you want to show. Something along these lines: select activity_seq, amount, unit, sys_code, code from GL_Ledger_Xunionselect activity_seq, AMT as amount, ‘’ as unit, ‘’ as sys_code, ‘’ as code from Budget_Y where activity_seq not in (select activity_seq from GL_Ledger_X where activity_seq is not null) Note this does mean you won’t get the AMT from Budget_Y for any activities which exist in GL_Ledger_X but it wasn’t clear whether you needed that or not. If you do, then you’ll have to do a view combining both tables and then query that with a group by to sum the amounts.Hope this helps.
HiIt’s difficult to tell without more information and it doesn’t look like your screenshots are showing the same data, but is it possible that there’s a mismatch in either date or number formatting due to different regional settings?For example, is Excel expecting a period (dot) as the decimal indicator rather than a comma?
Hi,Have you tried refreshing the server cache?
Hi Bjorn,Thank you for your response, but it looks like the navigation from a lobby is more flexible because you can enter it as free text. A tree/ option doesn’t seem to exist in the list of pages I can select from in the Page Designer.
HiThe API for each projection is defined separately, so it will depend exactly which sales pricing you want to update. If it is the price on the Sales Part page then the projection to use is SalesPartHandling.Assuming you are using Cloud, navigate to the API Explorer, search for the SalesPartHandling in the projection then select ‘Documentation → API Doc’ from the three dots.
Sorry, forget that. The source of the problem was a setting on the sales part, not the fact there was an export licence.
HiThe error appears to be referring to the ‘Supplier for Purchase Part’, not the PO itself.The ‘Supplier for Purchase Part’ is site specific. Is the supplier on the PO set up as a supplier for each part on the PO for the new site?Hope this helps!
Hi @kvbeWe’ve been able to view the IC_ tables using quick reports without any problems. You don’t need the _TAB at the end of the name. If you still get permission problems, have you tried when you’re logged in as IFSAPP?I don’t know what the overall limit on attributes would be, hopefully someone else can help you with that.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
