Data Migration

This will include topics related to data migration.

  • 418 Topics
  • 1,084 Replies

418 Topics

N
Do Gooder (Customer)
Nico13
asked in Data Migration

IFS REST API -- Lobster Middleware

Hi,when sending a HTTP Post request to IFS REST API I get an 400 error as respone.On the IFS Server I see this log message:2023/10/06 06:31:12 [warn] 96#96: *149147568 [lua] cookie.lua:146: bake(): SameSite value must be 'Strict', 'Lax' or 'None' while connecting to upstream, client: x.x.x.x, server: IFS, request: "POST /main/ifsapplications/projection/v1/LocationHandling.svc/LocationSet HTTP/1.1", host: "IFS"The Post request is initiated by our Lobster middleware, using postman everything is working fine. When doing a HTTP Get to request data it is working as epected.Is there some config missing in IFS regarding SameSite cookies or do we have to configure something ob Lobster-side?Thanks,best regards,Nico

6
hhy38
Hero (Customer)
6 months ago
B
Do Gooder (Customer)
bpamlinDo Gooder (Customer)
asked in Data Migration

Invalid data source definition when migrating lobbies from IEE to Aurena

I have a lobby that is working in IEE and returning data. But when migrating from IEE to Aurena. I get an invalid data source definition error. The client type is set to Aurena. IN AURENA IN IEE data source:   Also the elements that are returning data are returning null values. Any ideas why this is?

0
B
Do Gooder (Customer)
7 months ago
jascoetsee
Do Gooder (Partner)
jascoetseeDo Gooder (Partner)
asked in Data Migration

Data Migration Manager - Define Installed Environment

Hi,I am trying to complete the task to Define Installed Environment after completing the Basic Project Data for a Data migration job. I am however getting the below error; How can I change the Thousand Separator Format value? 

10
jascoetsee
Do Gooder (Partner)
7 months ago
C
Do Gooder (Partner)
CSGarethFDo Gooder (Partner)
asked in Data Migration

Migration Project Template files

Is there a defined location where we can get the Project Template files for Data Migration Manager for the latest release?  The training says it is recommended to use them, but as Partners I cant see where we would get them from.There is a topic where someone has kindly shared the files for 22r1 But this is now out of date as 23r1 has been released.It would be preferred if these template files were made available in a known place for Partners so we can use them in our Customer Projects.In the meantime, can anyone share the 23r1 Project Template?Gareth

5
Y
Do Gooder (Partner)
5 months ago
Disna Marakkala
Sidekick (Employee)
Disna MarakkalaSidekick (Employee)
asked in Data Migration

IFS 23R1 DMM - Error when Importing Template Project file

Hi,When importing the template project file for 23R1 I get below error message.  From Background job error textunable to extend index IFSAPP.DAT_TEMPLATE_LOAD_PK by 128 in tablespace IFSAPP_INDEX     ORA-20110: DatFileOperationUtil.ORA-01654Has anyone encounter the same error or can help to resolve this error please?I was using IFS demo environment https://ifs23r1costestlkp.rnd.ifsdevworld.com/  with Alain credentials to import the template project. Thanks!

2
Disna Marakkala
Sidekick (Employee)
7 months ago
D
Hero (Customer)
dmanueleHero (Customer)
asked in Data Migration

Invalid or control characters in xml file

I am trying to import supplier records into my IFS8 system using xml files generated by an external system. The xml files are supposed to be using utf-8 encoding. However, because some of the records are generated from Korean and Ukrainian sources, not all the characters are utf-8 despite the xml referencing <?xml version="1.0" encoding="UTF-8"?>. As a result, when the connector reader gets the xml file, it reports:com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: Invalid byte 1 of 1-byte UTF-8 sequence.And the file is not processed any further.Sometimes the control characters will clobber the xml tags, which nullifies the entire file structure.Aside from forcing the sender to reformat the data, is there anything I can do in IFS to compensate for the bad characters when the connector reader tries to pick it up?Here is an example of one of the bad xml files opened in notepad++.  

0
D
Hero (Customer)
7 months ago
L
Do Gooder (Customer)
lgcSandraDo Gooder (Customer)
asked in Data Migration

Data Synchronization

Hi Community. I am having a first look at the Dat Synchronization functionality on IFS Cloud.Documentation is not bad as overview of different aspects, but as a start point, a bit difficult to follow up.Is anyone out there with experience on setting it up, that would be willing to share that knowledge?Thanks for your time!  

1
L
Do Gooder (Customer)
7 months ago
B
Do Gooder (Customer)
BenHugDo Gooder (Customer)
asked in Data Migration

PickSelected API

Good morning everyone, I post this topic cause after many hours of research I can’t find a solution about using an API.Here is my problem :  I have to build an flow for make an insertion of data in IFS DB.I did it on the application and use the debug window for see what kind of API is called. After analyse, I see this :   I understood the parameters are checked in the FndTempsLobs API which is genering a LobID and this LobID is the payload of the PickSelected API. My question is : How can I give the inforamtion PICK_LIST_NO, SOURCE_REF1, QTY_TO_PICK, etc… to the FndTempsLobs API ? The documentation show us the only payload is CreatedByModule :  My 2nd question is : The LobID generated contains the previous information ?  Thx a lot for your help and sorry if my explication are confused.  

3
hhy38
Hero (Customer)
7 months ago
A
Do Gooder (Partner)
AmineMedDo Gooder (Partner)
asked in Data Migration

Saving data to Multiple tables

Hello,I am using an external Excel/CSV file as a source, imported by the user into a specific IFS repository. After importing and retrieving the data, I need to store it in multiple IFS tables.Could you please provide guidance on how to achieve this?

0
A
Do Gooder (Partner)
7 months ago
darshana
Sidekick (Employee)
darshanaSidekick (Employee)
asked in Data Migration

download docker container and heml chart for AirGap installation

Any one know how to download docker container and heml chart for AirGap installation for IFSCloud 23R1?Where should i find the “download.sh” file?  ./download.sh -u your_username -p your_password -j jfrog_artifactory_url -r x.y.z --ifs-helm 

1
S
Do Gooder (Employee)
7 months ago
A
Sidekick (Partner)
ArcElhadCSidekick (Partner)
asked in Data Migration

Migration job Based on new service ressource assistant creation

Hello want to build migration job wich based on the service resource assistant creation. The reousrce will be based on existing person and resource group. Is it something we can do by using the API method ? and if yes where i can find list of method of this API or have acces to the view.New service resource creation 

0
A
Sidekick (Partner)
7 months ago
M
Do Gooder
melissahankinsDo Gooder
asked in Data Migration

What criteria should businesses consider when choosing a cloud service for their IFS implementation?

Hello IFS Community, I hope you're all doing well. I'm currently in the process of evaluating cloud services for our IFS (Industrial and Financial Systems) implementation, and I wanted to reach out to this knowledgeable community to gather insights and recommendations on the criteria we should consider when making this important decision. Choosing the right cloud service provider is pivotal to the success and efficiency of our IFS deployment. Here are a few questions and criteria I've been pondering: Scalability: How well does the cloud service provider accommodate the scalability needs of IFS as our business grows? What are the options for scaling up or down, and how easy is it to implement these changes?Security and Compliance: What security measures and compliance certifications should we look for to ensure that our sensitive data and operations meet industry standards and regulatory requirements?Performance and Reliability: Can we rely on the cloud service to deliver consistent per

0
M
Do Gooder
7 months ago
C
Do Gooder (Customer)
CherylLausDo Gooder (Customer)
asked in Data Migration

Data Migration Manager Legacy Table joins

Just starting out with DMM in IFS Cloud 22R2. I need to pull data from two tables into one target table. The documentation indicates how legacy tables are joined is important but gives no information on how to do this.Somehow this worked when there were two legacy tables with the same key simply by identifying the keys on the Legacy Table definitions.In this new situation, there are three tables involved and I need data from tables T1 & T3. T1 and T2 have the same key. I labeled them Key 1 & 2.T2 and T3 are linked by a different field. I tried labeling these as Key 3, but that did not work.Is this possible to do and if so how?  

8
Nirogini Janstin
Do Gooder (Employee)
7 months ago
Disna Marakkala
Sidekick (Employee)
Disna MarakkalaSidekick (Employee)
asked in Data Migration

DMM- 'Expand Scope by Target Table's References One Level' hangs up - IFS 23R1

HI All,I got the below situation recently for a customer environment in IFS Cloud 23R1. I  had only CUSTOMER_INFO and CUSTOMER_INFO_ADDRESS target tables were marked as ‘In Scope’. When clicked on Expand Scope by Target Table's References One Level, it was taking long time and hung up.Have anyone of you experienced this ?Do you know any particular reason for this and how to overcome this issue?  Thanks in advance!  

2
Disna Marakkala
Sidekick (Employee)
7 months ago
darshana
Sidekick (Employee)
darshanaSidekick (Employee)
asked in Data Migration

IFSCloud Remote delivery failed

 During the installation of version 1.2.0, we encountered an issue with the delivery process known as the 'Delivery Not in Sequence Error'. It appears that the delivery order was not completed correctly. I have attached a screenshot for further information.  

1
darshana
Sidekick (Employee)
7 months ago
darshana
Sidekick (Employee)
darshanaSidekick (Employee)
asked in Data Migration

License process for IFSCloud remote deployment.

How to find the LTU user list? Who should import the licenses to the application?  Migrated from IFS 9 to IFS cloud through DB upgrade all the users are also active without importing  new license key, if there is any additional users are requested by customer, so do we need to get the new license from IFS and what is the process of this? what are the steps which we needs follow to import the new license key in IFS cloud instance which will be issued by IFS, NOT able to find import option in the system. 

1
B
Sidekick (Employee)
8 months ago
B
Do Gooder (Customer)
brmoDo Gooder (Customer)
asked in Data Migration

Add a timestamp field

Hello,In order to load data from INVENTORY_TRANSACTION_HIST2 to DW, it took a lot of time, actually using OBJVERSION to load a latest one but still taking 2 hours only for this table. Is is possible to add a timestamp field directly to a view INVENTORY_TRANSACTION_HIST2, and if any information change in a row the timestamp will be updated ? 

2
B
Do Gooder (Customer)
7 months ago
S
Do Gooder (Customer)
SSOLERDo Gooder (Customer)
asked in Data Migration

How to use Excel Migration to update Custom Field

Hello All,I'm looking for guidance on how to update a custom field in IFSAPP9 using an Excel Migration job. While I've created several migration job in the past this is the first one I'm creating that requires me to dump data into a custom field. The Custom field Is named HB_Origin. when looking at the debug console I see that IFS use the OBJID to update the field. How can get the OBJID from the Part_No the end user enters?  

1
E
Do Gooder
8 months ago
J
Hero (Customer)
JannetteCHero (Customer)
asked in Data Migration

Data migration error - APPS 10

I am trying to update CUST_ORDER_TEMPLATE_LINE but am getting the error message ORA-20121: CustOrderTemplateLine.INSERT: Field [LINE_NO] in Cust Order Template Line may not be specified for new objects. How do I rectify this please ? ​​​​​​I have also removed the field from the update but it is not creating any new records just updating the records.

1
N
Do Gooder (Partner)
1 month ago
MLHSKULKARNI
Do Gooder (Customer)
MLHSKULKARNIDo Gooder (Customer)
asked in Data Migration

Service Contract creation in IFS Cloud

hiI am looking for some ways how I can create service contracts easily in IFS without manually creating them.I can get service contract on paper( could be hand written) or I can get in excel.  This is kind of urgent. as we have lot of service contract to be created I am trying to see my ways . Appreciate any help/

0
MLHSKULKARNI
Do Gooder (Customer)
8 months ago
jzouaoui
Sidekick (Customer)
jzouaouiSidekick (Customer)
asked in Data Migration

Data load definition BI Error

Hello, I need to run a data load for the General Ledger . and i get the error below : The AD user Mapping already addedd :  and i executed  the environment Set up after addinf the AD user Mapping .But i still get the same Error .Need Help Please :) 

2
jzouaoui
Sidekick (Customer)
8 months ago
C
Do Gooder (Customer)
CloudDo Gooder (Customer)
asked in Data Migration

Migration Job for a Customer Order that contains more than 100 lines

Hello everyone,I have met one tough problem from time to time. I often need to upload Customers’ Purchase Order into IFS 10. Most formats of theses POs are PDF, and they contain less than 20 lines, in this case, I would upload them into IFS manually. But there are some POs in Excel format and contain more than 100 lines (we can see Sales Part Number, Quantity, Unit Price with Currency, Wanted Delivery Date, etc. In short, all the key information is provided) It may take me more than one hour to deal with it if I choose to set up it in IFS and this is what I did for a several times before. Time-consuming job!!! So, does anyone here know how to do migration job for upload one PO of Excel format containing more than 100 lines one time? Also, does anyone here know how to create a lot of sales parts (usually more than 50) one time? All the sales parts belong to the same product family. A lot thanks.Please share the method or guidance with me if you don’t mind, thanks a lot in advance.Your a

2
NikhilMalik
Sidekick (Employee)
8 months ago
E
Do Gooder (Customer)
Eesha1753Do Gooder (Customer)
asked in Data Migration

Navigation command to specific page stuck

Hello!I’m trying to find out why my Navigation Link Command is not taking me to the correct page. The name; CPEGEN_OpportunityLinesList_NavigateToForm(1) is correct but the NavigationToForm(1) is navigating to the wrong page. Is there a way for me to find out why this is happening or a way to configure NavigateToForm(1) to the right page^

1
EntNadeeL
Hero (Partner)
8 months ago
D
Do Gooder (Customer)
dlyon6Do Gooder (Customer)
asked in Data Migration

Copying from one site to another

We are setting up an additional Site within one of our companies, and would like to know if there is a quick way to “copy” from site A to B.  If so, what are the parameters that are copied over?   Thanks DAVE 

0
D
Do Gooder (Customer)
8 months ago
C
Do Gooder (Employee)
clwilkDo Gooder (Employee)
asked in Data Migration

What are the restrictions when linking / migrating files with other systems ?

Hi All,What are the file size limitations for data migrations? For example, when migrating text and JSON files, are there any specific constraints? Additionally, is there a character code specification and delimiter specification involved ?

0
J
Do Gooder
8 months ago

Badges

Show all badges
Terms & ConditionsCookie settings