Getting an error message "Connection reset by peer"
I'm using a custom driver to connect to an HP Vertica Instance provided to us by GoodData. Until Saturday, I was able to connect without issue then I started getting a message indicating that the connection was reset by a peer. Now I am unable to connect at all.
I'm using a custom driver to connect to an HP Vertica Instance provided to us by GoodData. Until Saturday, I was able to connect without issue then I started getting a message indicating that the connection was reset by a peer. Now I am unable to connect at all.
It sounds like someone changed the credentials/authorization in the database. Maybe more security was added or the password was changed? You are getting this error using Aqua Data Server? Have you tried connecting to the database using Aqua Data Studio?
Tom Hi Rick,
It sounds like someone changed the credentials/authorization in the database. Maybe more security was added or the password was changed? You are getting this error using Aqua Data Server? Have you tried connecting to the database using Aqua Data Studio?
Tom
Where do I find end of support dates for Studio & Server products ?
1評論
-
NielsGron
NielsGron
2017-03-27T18:04:26Z Support is based on the end of a customers subscription service. Support for versions older the 2 versions previous to the current version can be confirmed by emailing [email protected]Support is based on the end of a customers subscription service. Support for versions older the 2 versions previous to the current version can be confirmed by emailing [email protected]
Are there any plans to support viewing a VA workbook created in Data Studio in Data Server? We are looking for a solution that would allow a developer to create workbooks that we can then easily expose to the business, say by running automatically (say nightly) that could then be viewed static, or that run on demand when viewed, or maybe even just display the data statically like a packaged workbook does.
I've looked at the ability to create dashboards and reports within Data Server but it seems to require more development effort/knowledge then it does to create a VA workbook in Data Studio-- hence limits the resources we have ability to put onto dashboard creation tasks.
We've bought a couple of additional Data Studio licenses for business users, but that only helps for packaged workbooks (as they usually don't/won't have direct access to the databases). And honestly, this approach is pretty cost prohibitive.
Thanks, -J
Hi,
Are there any plans to support viewing a VA workbook created in Data Studio in Data Server? We are looking for a solution that would allow a developer to create workbooks that we can then easily expose to the business, say by running automatically (say nightly) that could then be viewed static, or that run on demand when viewed, or maybe even just display the data statically like a packaged workbook does.
I've looked at the ability to create dashboards and reports within Data Server but it seems to require more development effort/knowledge then it does to create a VA workbook in Data Studio-- hence limits the resources we have ability to put onto dashboard creation tasks.
We've bought a couple of additional Data Studio licenses for business users, but that only helps for packaged workbooks (as they usually don't/won't have direct access to the databases). And honestly, this approach is pretty cost prohibitive.
Thanks,
-J
In our product roadmap, we do have plans to add VA workbooks created in Data Studio in Data Server. Our Data Server product supports our older generation charting APIs but doesn't support the VA charting mechanism. We do have plans to add this functionality in Data Server but don't have any definitive timelines. Hi Jason,
In our product roadmap, we do have plans to add VA workbooks created in Data Studio in Data Server. Our Data Server product supports our older generation charting APIs but doesn't support the VA charting mechanism. We do have plans to add this functionality in Data Server but don't have any definitive timelines.
JasonK
2016-06-08T19:10:54Z Good news. Too bad it's not today ;) If you need any customers asking for this so you can bump the priority, consider this an ask ;)
Do you have a ticket for this addition that I can start watching?Good news. Too bad it's not today ;) If you need any customers asking for this so you can bump the priority, consider this an ask ;)
Do you have a ticket for this addition that I can start watching?
On the issue, you can click "Like" on it. The more "Likes", the greater the priority bump :)I've created a new issue for it:
https://www.aquaclusters.com/app/home/project/public/aquadataserver/issue/2967
On the issue, you can click "Like" on it. The more "Likes", the greater the priority bump :)
I attempted an upgrade of one of my ADS instances from 13 to 16, but I'm unable to get the application to start. It's throwing a servlet exception. I'm attaching the catalina log from where it attempted and failed to start.
Hey Guys,
I attempted an upgrade of one of my ADS instances from 13 to 16, but I'm unable to get the application to start. It's throwing a servlet exception. I'm attaching the catalina log from where it attempted and failed to start.
Let us know if you have any more questions.Hi Brian,
1. Can you tell us what error message you are getting? Can you attach a screenshot of the error?
2. Can you also send us your tomcat and aquadataserver.log files? Here is the docs on logs :
https://www.aquaclusters.com/app/home/project/public/aquadataserver/wikibook/Documentation16/page/28/3-5-Tomcat-Aqua-Data-Server-Logs
3.Did you follow the Upgrade process as in the link here: https://www.aquaclusters.com/app/home/project/public/aquadataserver/wikibook/Documentation16/page/82/2-9-Upgrading#upgradingwindows
3.1 As part of the upgrade process, you would need to configure your database as in the below link:
https://www.aquaclusters.com/app/home/project/public/aquadataserver/wikibook/Documentation16/page/27/3-4-Database-Repository-Configuration
Let us know if you have any more questions.
I have a query which runs in Aqua Data Studio, but not in Aqua Data Server. If I execute an Aquascript on the server from the 'edit' screen, I get a console message:
Error on line 16: Unexpected token NAME (#16)
But, if I take the query portion of the script, modify it to run in Aqua Data Studio, it works. I can use Studio to generate a new Aquascript, but it seems that a working Studio query should work in Server.
I've attached the aquascript.
I have a query which runs in Aqua Data Studio, but not in Aqua Data Server. If I execute an Aquascript on the server from the 'edit' screen, I get a console message:
Error on line 16: Unexpected token NAME (#16)
But, if I take the query portion of the script, modify it to run in Aqua Data Studio, it works. I can use Studio to generate a new Aquascript, but it seems that a working Studio query should work in Server.
I've attached the aquascript.
I have edited the AquaScript and attached one that works. There was a syntax error in Line# 16 where you had not escaped the quote identifier resulting in a Javascript syntax error.
You can either enclose the query within double quotes as in query = "SELECT …."; or escape the quote identifiers using a \ character as in AS \'Last Call\'
Let us know if you have any more questions
ThanksHi Andrew,
I have edited the AquaScript and attached one that works. There was a syntax error in Line# 16 where you had not escaped the quote identifier resulting in a Javascript syntax error.
You can either enclose the query within double quotes as in query = "SELECT ….";
or escape the quote identifiers using a \ character as in AS \'Last Call\'
Let us know if you have any more questions
Thanks
I've been trying to access the OpenAPI documentation, but the page is blank with no content:
http://docs.aquafold.com/ads/14.0/openapi/
Can you check that the link is working?
Thank you.
emilianbold
2014-03-25T16:26:03Z Make sure you don't have some ad-blocker blanking your page because of the "/ads/" text in the link.Make sure you don't have some ad-blocker blanking your page because of the "/ads/" text in the link.
swissarmyknife(*)
2014-03-25T16:31:27Z I'm able to see this page through both our internal network and through an external network (AT&T - Safari on my iPhone). Can you provide some details on what browser/OS you are using to view the page? Are you able to view the link below?
(that link should look like our www.aquafold.com home page)I'm able to see this page through both our internal network and through an external network (AT&T - Safari on my iPhone). Can you provide some details on what browser/OS you are using to view the page? Are you able to view the link below?
http://docs.aquafold.com/
(that link should look like our www.aquafold.com home page)
amelton
2014-03-25T17:44:21Z Must be a browser issue. It works on my iPhone, but none of my desktop browsers will display. Thanks, I'll continue investigating my side.Must be a browser issue. It works on my iPhone, but none of my desktop browsers will display. Thanks, I'll continue investigating my side.
emil.goicovici
2014-03-25T18:15:38Z
·
(修改過) I also think he has some ad-blocker (like Adblock Plus etc). I use such an ad-blocker and when opening the reported link it displays only two HTML frames with no content on them. The ad-blocker reports that three items (the inner frames) were blocked on that page.
After I temporarily disable the ad-blocker rules for that page, and reload it on my browser, it successfully displays the OpenAPI documentation.I also think he has some ad-blocker (like Adblock Plus etc). I use such an ad-blocker and when opening the reported link it displays only two HTML frames with no content on them. The ad-blocker reports that three items (the inner frames) were blocked on that page.
After I temporarily disable the ad-blocker rules for that page, and reload it on my browser, it successfully displays the OpenAPI documentation.
I have a table with two columns: `Name` and `City`. I would like to create an Aquascript that would prompt the user to supply a name and output a table with the number of occurrences of `name` by `city`.
The sql would be something like:
select count(1),city from records where name like 'xxxxxxx' group by city
I tried slimming down the "Company Revenue Advanced" example, but that was more than I needed. Can you assist in creating the above?
Thanks.
I have a table with two columns: `Name` and `City`. I would like to create an Aquascript that would prompt the user to supply a name and output a table with the number of occurrences of `name` by `city`.
The sql would be something like:
select count(1),city from records
where name like 'xxxxxxx'
group by city
I tried slimming down the "Company Revenue Advanced" example, but that was more than I needed. Can you assist in creating the above?
Thanks.
I have created a very simple script which will accept city name as the user input and will display the count. See attached screenshots and Sample.xjs. I basically worked on the Company Revenue Advanced and trimmed out items like Export, Email which you can add easily. Let us know if you need anything else
The table structure I used is below:
CREATE TABLE city ( Name varchar(25) NOT NULL, City varchar(25) NOT NULL ) ENGINE = InnoDB GO
Thanks.Hello Andrew,
I have created a very simple script which will accept city name as the user input and will display the count. See attached screenshots and Sample.xjs. I basically worked on the Company Revenue Advanced and trimmed out items like Export, Email which you can add easily. Let us know if you need anything else
The table structure I used is below:
CREATE TABLE city (
Name varchar(25) NOT NULL,
City varchar(25) NOT NULL
)
ENGINE = InnoDB
GO
Thanks.
Hi Rick,
It sounds like someone changed the credentials/authorization
Tom
Hi Rick, It sounds like someone changed the credentials/authorization in the database. Maybe more security was added or the password was changed? You are getting this error using Aqua Data Server? Have you tried connecting to the database using Aqua Data Studio? Tom