MySQL Server: Time zone value unrecognized #
The server time zone value ‘EDT’ is unrecognized or represents more than the onetime zone. The user must configure either the server or JDBC driver (via the server timezone configuration property) to use a more specific time zone value if the user wants to utilize time zone support.
[su_box title=”Note” box_color=”#2a8af0″ title_color=”#000000″]server time zone is based on MySQL installed on the user server.[/su_box]
Package Size on the interface when we filled in Agent UI doesn’t update on SF #
When user try to filled package size in Agent UI it doesn’t update on SF.
Expectation: The package size when we filled in Agent UI must be update on SF.
Steps :
- Navigate to Agent application
- Enter to Integration Wizard
- Select Property File
- Interface Source Definition
- Filled on package size
- Save
Result: The package size on the interface doesn’t update on SF.
Case 1: Filled Package size on Agent UI
Expectation: When we filled the package size in Agent UI the package size will be updated on SF in Interface Detail.
- Create integration and interface
- Navigate to Agent UI
- Integration Wizard
- Select Property File
- Choose Integration
- Double-click on the interface(PackageSize)
- Filled on Package Size
Case 2: Filled package size on SF
Expectation: When we filled the package size on Interface Detail the package size will be updated on Agent UI
Go to SF –Interface Detail then filled in the package size
The agent cannot process attachments when attachment doesn’t have in the folder #
When the attachment was missing from the folder Agent cannot process it.
Expectation: If the attachment doesn’t have it in the folder, the Agent must be continuing the processing, and create the Failed message: “System cannot find file specified id=……”
Hard Deleted doesn’t work with the database #
- To delete data all the user need is a record that contains the IDs of the objects the user wants to delete in one of the columns. Once you have this, proceed with the instructions below.
- In SKYVVA Agent, before actually deleting the data you must first create an interface outbound. When the user creates a Mapping check on the flag Use Streaming API and also click on Subscribe button.
- The beauty of doing things this way is that On Notification For Operation Deleted and then Operation Deleted is Hard Deleted.
Login wrong Server Environment #
If logins are getting locked, log in to the wrong Server Environment which indicates the password is incorrect. Either the server has the incorrect password recorded for the login, or the client is presenting the wrong password.
- Since this is a mirroring environment.
- We’d bet the client is using the same password for both instances.
- Meaning the password for the login on the mirror is not the same as the password for the login on the master.
- Recreate the login on the mirror server with the known-good password, i.e. not the hashed version.
Ensure you get the SID correct (use copy-and-paste) from this query, ran against the principal server because it is case sensitive.
The scheduler is working when it Stopped #
When the scheduler run one time and then the user stops the schedule
Result: The schedule is still working.
Expected Result: When the user stops the schedule it must stop working.
