· 7 years ago · Dec 18, 2018, 09:38 AM
1//creating local file
2 try {
3 FileOutputStream fileOut = new FileOutputStream(new File("C:\test.xls"));
4 excelWorkBook.write(fileOut);
5 fileOut.flush();
6 fileOut.close();
7
8 } catch (Exception e) {
9 // TODO Auto-generated catch block
10 e.printStackTrace();
11 }
12
13com.amazonaws.services.s3.model.AmazonS3Exception: Status Code: 400, AWS Service: Amazon S3, AWS Request ID: BC86F8AED980C7A3, AWS Error Code: RequestTimeout, AWS Error Message: Your socket connection to the server was not read from or written to within the timeout period. Idle connections will be closed., S3 Extended Request ID: P1yiux9HeVH92ifelvhMfTyQ27Hgu3sC4xx8DXstO+HLizMera2OkYv3BSVCEJtxtFz10/SRbMk=
14 at com.amazonaws.http.AmazonHttpClient.handleErrorResponse(AmazonHttpClient.java:767)
15 at com.amazonaws.http.AmazonHttpClient.executeHelper(AmazonHttpClient.java:414)
16 at com.amazonaws.http.AmazonHttpClient.execute(AmazonHttpClient.java:228)
17 at com.amazonaws.services.s3.AmazonS3Client.invoke(AmazonS3Client.java:3316)
18 at com.amazonaws.services.s3.AmazonS3Client.putObject(AmazonS3Client.java:1336)
19 at com.sterling.smartdata.service.upload.impl.UploadReportImpl.uploadToCloud(UploadReportImpl.java:96)
20 at com.sterling.smartdata.service.upload.impl.UploadCloudLocalImplTest.testUpload(UploadCloudLocalImplTest.java:33)
21 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
22 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
23 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
24 at java.lang.reflect.Method.invoke(Unknown Source)
25 at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
26 at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
27 at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
28 at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
29 at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
30 at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:74)
31 at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:85)
32 at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:86)
33 at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
34 at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:241)
35 at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:87)
36 at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
37 at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
38 at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
39 at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
40 at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
41 at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
42 at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)
43 at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
44 at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:180)
45 at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86)
46 at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
47 at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459)
48 at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:678)
49 at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382)
50 at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192)
51
52public void uploadToCloud() {
53 AWSCredentials credentials = new BasicAWSCredentials(
54 accessKey,
55 secretKey);
56
57 AmazonS3 s3client = new AmazonS3Client(credentials);
58
59 HSSFWorkbook excelWorkBook=new HSSFWorkbook();
60 missingAbbreviationReport.createMissingChargeAbbreviationSheet(excelWorkBook);
61 missingAbbreviationReport.createMissingDispositionAbbreviationSheet(excelWorkBook);
62
63 //creating local file
64 try {
65 FileOutputStream fileOut = new FileOutputStream(new File("C:\test.xls"));
66 excelWorkBook.write(fileOut);
67 fileOut.flush();
68 fileOut.close();
69
70 } catch (Exception e) {
71 // TODO Auto-generated catch block
72 e.printStackTrace();
73 }
74
75
76 //upload to amazon s3
77 ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
78 try {
79 excelWorkBook.write(byteArrayOutputStream);
80 byteArrayOutputStream.close();
81 } catch (IOException e) {
82
83 LOGGER.error(e.getMessage());
84 }
85
86 byte[] bf=new byte[byteArrayOutputStream.toByteArray().length];
87 ByteArrayInputStream bi=new ByteArrayInputStream(bf);
88 try {
89 bi.read(byteArrayOutputStream.toByteArray());
90 } catch (IOException e) {
91 // TODO Auto-generated catch block
92 e.printStackTrace();
93 }
94
95
96
97 ObjectMetadata objectMetaData =new ObjectMetadata();
98 objectMetaData.setContentType("application/vnd.ms-excel");
99 objectMetaData.setContentLength(byteArrayOutputStream.toByteArray().length);
100
101 s3client.putObject(new PutObjectRequest("smartdata-missingslg-reports", "test.xls",bi,objectMetaData) );
102
103 }
104
105byte[] bf=new byte[byteArrayOutputStream.toByteArray().length];
106ByteArrayInputStream bi=new ByteArrayInputStream(bf);
107
108ByteArrayInputStream bi= ByteArrayInputStream(byteArrayOutputStream.toByteArray());
109
110[12/14/18 13:08:14:436 IST] 000000ee SystemErr R com.amazonaws.SdkClientException: Data read has a different length than the expected:
111 dataLength=0;
112 expectedLength=165376;
113 includeSkipped=false;
114 in.getClass()=class com.amazonaws.internal.ReleasableInputStream;
115 markedSupported=true;
116 marked=0;
117 resetSinceLastMarked=false;
118 markCount=1;
119 resetCount=0
120[12/14/18 13:08:14:437 IST] 000000ee SystemErr R at com.amazonaws.util.LengthCheckInputStream.checkLength(LengthCheckInputStream.java:151)
121[12/14/18 13:08:14:437 IST] 000000ee SystemErr R at com.amazonaws.util.LengthCheckInputStream.read(LengthCheckInputStream.java:109)
122[12/14/18 13:08:14:437 IST] 000000ee SystemErr R at com.amazonaws.internal.SdkFilterInputStream.read(SdkFilterInputStream.java:90)
123[12/14/18 13:08:14:437 IST] 000000ee SystemErr R at com.amazonaws.services.s3.internal.MD5DigestCalculatingInputStream.read(MD5DigestCalculatingInputStream.java:128)
124[12/14/18 13:08:14:437 IST] 000000ee SystemErr R at com.amazonaws.internal.SdkFilterInputStream.read(SdkFilterInputStream.java:90)
125[12/14/18 13:08:14:437 IST] 000000ee SystemErr R at com.amazonaws.event.ProgressInputStream.read(ProgressInputStream.java:180)
126[12/14/18 13:08:14:437 IST] 000000ee SystemErr R at com.amazonaws.internal.SdkFilterInputStream.read(SdkFilterInputStream.java:90)
127[12/14/18 13:08:14:438 IST] 000000ee SystemErr R at org.apache.http.entity.InputStreamEntity.writeTo(InputStreamEntity.java:142)
128[12/14/18 13:08:14:438 IST] 000000ee SystemErr R at com.amazonaws.http.RepeatableInputStreamRequestEntity.writeTo(RepeatableInputStreamRequestEntity.java:160)
129[12/14/18 13:08:14:438 IST] 000000ee SystemErr R at org.apache.http.impl.DefaultBHttpClientConnection.sendRequestEntity(DefaultBHttpClientConnection.java:158)
130[12/14/18 13:08:14:438 IST] 000000ee SystemErr R at org.apache.http.impl.conn.CPoolProxy.sendRequestEntity(CPoolProxy.java:162)
131[12/14/18 13:08:14:438 IST] 000000ee SystemErr R at org.apache.http.protocol.HttpRequestExecutor.doSendRequest(HttpRequestExecutor.java:237)
132[12/14/18 13:08:14:439 IST] 000000ee SystemErr R at com.amazonaws.http.protocol.SdkHttpRequestExecutor.doSendRequest(SdkHttpRequestExecutor.java:63)
133[12/14/18 13:08:14:439 IST] 000000ee SystemErr R at org.apache.http.protocol.HttpRequestExecutor.execute(HttpRequestExecutor.java:122)
134[12/14/18 13:08:14:439 IST] 000000ee SystemErr R at org.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:271)
135[12/14/18 13:08:14:439 IST] 000000ee SystemErr R at org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:184)
136[12/14/18 13:08:14:439 IST] 000000ee SystemErr R at org.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:184)
137[12/14/18 13:08:14:439 IST] 000000ee SystemErr R at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:82)
138[12/14/18 13:08:14:439 IST] 000000ee SystemErr R at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:55)
139[12/14/18 13:08:14:439 IST] 000000ee SystemErr R at com.amazonaws.http.apache.client.impl.SdkHttpClient.execute(SdkHttpClient.java:72)
140[12/14/18 13:08:14:440 IST] 000000ee SystemErr R at com.amazonaws.http.AmazonHttpClient$RequestExecutor.executeOneRequest(AmazonHttpClient.java:1285)
141[12/14/18 13:08:14:440 IST] 000000ee SystemErr R at com.amazonaws.http.AmazonHttpClient$R
142
143can you please help!!